User Guide

cfgridupdate 169
cfgridupdate
Description
Used within a cfgrid tag. Updates data sources directly from edited grid data. This tag provides
a direct interface with your data source.
This tag applies
delete row actions first, then insert row actions, then update row actions. If it
encounters an error, it stops processing rows.
Category
Forms tags
Syntax
<cfgridupdate
grid = "gridname"
dataSource = "data source name"
tableName = "table name"
username = "data source username"
password = "data source password"
tableOwner = "table owner"
tableQualifier = "qualifier"
keyOnly = "Yes" or "No">
See also
cfgrid, cfgridcolumn, cfgridrow, cfapplet, cfform, cfinput, cfselect,
cfslider, cftextinput, cftree
History
ColdFusion MX: Deprecated the connectString, dbName, dbServer, dbtype, provider and
providerDSN attributes. They do not work, and might cause an error, in releases later than
ColdFusion 5.
Attributes
Attribute Req/Opt Default Description
grid Required Name of cfgrid form element that is the source for the
update action.
dataSource Required Name of data source for the update action.
tableName Required Name of table to update.
For ORACLE drivers, entry must be upper-case.
For Sybase driver, entry is case-sensitive; must be same
case as used when table was created
username Optional Overrides username value specified in ODBC setup.
password Optional Overrides password value specified in ODBC setup.
tableOwner Optional Table owner, if supported.