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.

 <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

grid

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

datasource

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

tablename

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

username

Required: No
Overrides username specified in ODBC setup.

password

Required: No
Overrides password specified in ODBC setup.

tableowner

Required: No
Table owner, if supported.

tablequalifier

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.

keyonly

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