User Guide

170 Chapter 2: ColdFusion Tags
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>
...
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 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
Attribute Req/Opt Default Description