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

cfapplet, cfform, cfgrid tags, cfinput, cfselect, cfslider, cftextinput, cftree

History

New in ColdFusion MX: The connectString, dbName, dbServer, dbtype, provider and providerDSN attributes are deprecated. Do not use them. 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.
tableQualifier
Optional
 
Table qualifier, if supported. Purpose:
  • SQL Server and Oracle driver: name of database that contains table
  • Intersolv dBASE driver: directory of DBF files
keyOnly
 
No
Applies to the update action:
  • Yes: the WHERE criteria are limited to the key values
  • No: the WHERE criteria include key values and the original values of changed fields

Example

<!--- This example shows the cfgridupdate tag--->
...
<!--- If the gridEntered form field has been tripped, perform 
the gridupdate on the table specified in the database.
Using the default value keyonly = yes lets us change only the 
information that differs from the previous grid --->
<cfif IsDefined("form.gridEntered") is True>
<cfgridupdate grid = "FirstGrid" dataSource = "cfsnippets"
 tableName = "CourseList" keyOnly = "Yes">
</cfif>
...

Comments