Contents

cfgridupdate

Description

Used in a cfgrid, cfgridupdate allows you to perform updates to data sources directly from edited grid data. The cfgridupdate tag provides a direct interface with your data source. The cfgridupdate tag applies delete row actions first, then INSERT row actions, and then UPDATE row actions. If an error is encountered, row processing stops.

Category

Other

Implemented

Usage Syntax

<cfgridupdate  
	grid="String"
	dataSource="String"
	[dbType="String"]
	[dbServer="String"]
	[dbName="String"]
	tableName="String"
	connectString="String"
	[username="String"]
	[password="String"]
	[tableOwner="String"]
	[tableQualifier="String"]
	[provider="String"]
	[providerDSN="String"]
	[keyOnly="Boolean"]
 />

[] = Optional attribute

Attributes

Name Type Required Default Description
grid String Yes The name of the cfgrid form element that is the source for the update action.
dataSource String Yes The name of the data source for the update action.
dbType String No The database driver type
dbServer String No For native database drivers and the SQLOLEDB provider, specifies the name of the database server computer. If specified, dbServer overrides the server specified in the data source.
dbName String No The database name (Sybase System 11 driver and SQLOLEDB provider only). If specified, dbName overrides the default database specified in the data source.
tableName String Yes The name of the table to update.
connectString String Yes The contents of a connection string to send to the ODBC server. When connecting to a data source defined in the ColdFusion Administrator, you can use this attribute to specify additional connection details or to override connection information specified in the Administrator. If you are dynamically connecting to a datasource by specifying dbType = "dynamic", the connection string must specify all required ODBC connection attributes.
username String No If specified, username overrides the username value specified in the ODBC setup.
password String No If specified, password overrides the password value specified in the ODBC setup.
tableOwner String No For data sources that support table ownership (such as SQL Server, Oracle, and Sybase SQL Anywhere), use this field to specify the owner of the table.
tableQualifier String No For data sources that support table qualifiers, use this field to specify the qualifier for the table. The purpose of table qualifiers varies across drivers. For SQL Server and Oracle, the qualifier refers to the name of the database that contains the table. For the Intersolv dBase driver, the qualifier refers to the directory where the DBF files are located.
provider String No COM provider (OLE-DB only).
providerDSN String No Data source name for the COM provider (OLE-DB only).
keyOnly Boolean No Yes or No. Yes specifies that in the update action, the WHERE criteria is confined to the key values. No specifies that in addition to the key values, the original values of any changed fields are included in the WHERE criteria. Default is Yes.

Example Usage