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.
-
DBTYPE="database_type" The type of database driver to use. Optional. 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 installed on the ColdFusion server.
-
Oracle80 Connect using the Oracle 8 native driver. This requires the 8.0 or later client libraries be installed on the ColdFusion server.
-
Sybase11 Connect using the Sybase 11 native driver. This requires the 11.1.1 or later client libraries be installed on the ColdFusion server.
-
DB2 Connect using the DB2 5.2 native driver.
-
Informix73 Connect using the Informix 7.3 native driver. This requires the Informix SDK 2.5 or later or Informix-Connect 2.5 (or later) for Windows.
-
Query Specifies the query should use an already existing query as the data source. If this option is used, you don’t need to specify a value for
DATASOURCE. New as of ColdFusion 5.0.-
Dynamic Allows ColdFusion to make an ODBC connection to a data source without having to have the data source registered in the ColdFusion Administrator. When making a dynamic connection, all information normally ...
-
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access