Programming ColdFusion

Name

CFGRIDUPDATE

Synopsis

<CFGRIDUPDATE>

Updates records in a database using values passed from a CFGRID control.

Attributes

GRID=" grid_name "

Name of the grid control containing the data to be updated. Required.

DATASOURCE=" data_source_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

Make the connection 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 ...