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.

 <cfgridupdate grid="" datasource="" tablename="">

 cfgridupdate(grid="", datasource="", tablename="");

This tag requires Adobe ColdFusion. Not supported on Lucee, OpenBD, etc.

Attribute Reference for the cfgridupdate tag


Required: Yes
Name of cfgrid form element that is the source for the
update action.


Required: Yes
Name of data source for the update action.


Required: Yes
Table in which to insert form fields.

ORACLE drivers: must be uppercase.
Sybase driver: case-sensitive. Must be the same case used
when table was created


Required: No
Overrides username specified in ODBC setup.


Required: No
Overrides password specified in ODBC setup.


Required: No
Table owner, if supported.


Required: No
For data sources that support table qualifiers, use this
field to specify qualifier for table. The purpose of table
qualifiers varies among drivers. For SQL Server and
Oracle, qualifier refers to name of database that contains
table. For Intersolv dBASE driver, qualifier refers to
directory where DBF files are located.


Required: 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

Fork me on GitHub