Programming ColdFusion MX, 2nd Edition

Name

cfupdate

Synopsis

<cfupdate>

Updates records in a database. The cfupdate tag provides a way to update database records without having to wrap the SQL in a cfquery.

Attributes

datasource=" datasource_name "

The name of the data source to connect to when performing the update. Required.

connectstring=" connection_string "

Passes additional connection information to an ODBC data source that can’t be passed via the ColdFusion Administrator. connectstring can also override connection information set for a data source already registered in the ColdFusion Administrator. When making a dynamic data source connection (when dbtype is Dynamic), connectstring specifies all the information required to connect to the data source. For specific connection-string options, you should consult the documentation for your particular database. New as of ColdFusion 5.0. This attribute is no longer supported in ColdFusion MX.

dbname=" database_name "

The database name. For the Sybase System 11 native driver and SQLOLEDB provider only. Optional. Overrides any value set for datasource. This attribute is no longer supported in ColdFusion MX.

dbtype=" database_type "

The type of database driver to use. Optional. This attribute is no longer supported in ColdFusion MX. Possible choices are:

ODBC (the default)

Connect to the data source using an ODBC driver.

OLEDB

Connect using an OLEDB driver.

Oracle73

Connect using the Oracle 7.3 native driver. This requires the 7.3.4.0.0 or later client libraries be ...