Whatever message this page gives is out now! Go check it out!

cfgridupdate

Last update:
May 18, 2026

Description

Used with 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 = "grid name" 
 dataSource = "data source name" 
 tableName = "table name" 
 keyOnly = "yes|no"> 
 password = "data source password" 
 tableOwner = "table owner" 
 tableQualifier = "qualifier" 
 username = "data source user name">
Note: You can specify this tag's attributes in an attributeCollection attribute whose value is a structure. Specify the structure name in the attributeCollection attribute and use the tag's attribute names as structure keys.

See also

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

History

ColdFusion 10: Added the clientInfo attribute.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
clientInfo
Optional
Structure containing properties of the client to be set on the database connection.
grid
Required
Name of the cfgrid form element that is the source for the update action.
dataSource
Required
Name of the data source for the update action.
tableName
Required
Name of the 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.
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.
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 the table.
  • Intersolv dBASE driver: directory of DBF files.
username
Optional
Overrides username value specified in ODBC setup.

Example

The following example lets you update a database by using a cfgrid tag to add and delete entire records or to update the data in individual cells. The cfgridupdate tag processes the data from the submitted form and updates the database.
<!--- If the gridEntered form field exists, the form was submitted. Perform gridupdate. ---> 
<cfif IsDefined("form.gridEntered") is True> 
<cfgridupdate grid = "FirstGrid" dataSource = "cfdocexamples" Keyonly="true" 
tableName = "CourseList"> 
</cfif> 

<!--- Query the database to fill up the grid. ---> 
<cfquery name = "GetCourses" dataSource = "cfdocexamples"> 
SELECT Course_ID, Dept_ID, CorNumber, CorName, CorLevel, CorDesc 
FROM CourseList 
ORDER by Dept_ID ASC, CorNumber ASC 
</cfquery> 

<h3>cfgrid Example</h3> 
<I>Try adding a course to the database, and then deleting it.</i> 
<cfform> 
<cfgrid name = "FirstGrid" width = "450" 
query = "GetCourses" insert = "Yes" delete = "Yes" 
font = "Tahoma" rowHeaders = "No" 
colHeaderBold = "Yes" 
selectMode = "EDIT" 
insertButton = "Insert a Row" deleteButton = "Delete selected row" > 
</cfgrid><br> 
<cfinput type="submit" name="gridEntered"> 
</cfform>...

Share this page

Was this page helpful?
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Thank you for your feedback. Your response will help improve this page.

On this page