cfgridupdate

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.

Forms tags

<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">

cfgrid, cfgridcolumn, cfgridrow, cfapplet, cfform, cfinput, cfselect, cfslider, cftextinput, cftree

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.

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
 

<!--- 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>
...

View comments on LiveDocs