cfupdate

Updates records in a data source from data in a CFML form
or form Scope.

 <cfupdate datasource="" tablename="">

 cfupdate(datasource="", tablename="");

Attribute Reference for the cfupdate tag

datasource

Required: Yes
Name of the data source that contains the table

tablename

Required: Yes
Name of table to update.
For ORACLE drivers, must be uppercase.
For Sybase driver: case-sensitive; must be in same case
as used when the table was created

tableowner

Required: No
For data sources that support table ownership (for example,
SQL Server, Oracle, Sybase SQL Anywhere), the table owner.

tablequalifier

Required: No
For data sources that support table qualifiers. The purpose
of table qualifiers is as follows:
SQL Server and Oracle: name of database that contains
table
Intersolv dBASE driver: directory of DBF files

username

Required: No
Overrides username value specified in ODBC setup.

password

Required: No
Overrides password value specified in ODBC setup.

formfields

Required: No
Comma-delimited list of form fields to update.

If a form field is not matched by a column name in the
database, CFML throws an error.

The formFields lies must include the database table primary
key field, which must be present in the form. It can be
hidden.


Fork me on GitHub