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
cfgrid, cfgridcolumn, cfgridrow, cfapplet, cfform, cfinput, cfselect, cfslider, cftextinput, cftree
History
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.

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

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 |

Default value: "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