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
cfapplet, cfform, cfgrid tags, cfinput, cfselect, cfslider, cftextinput, cftree |
|
History
New in ColdFusion MX: The connectString, dbName, dbServer, dbtype, provider and providerDSN attributes are deprecated. Do not use them. 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:
|
KEYONLY | |
Default value: "No "
Applies to the update action:
|