MACROMEDIA COLDFUSION 4.5-CFML LANGUAGE, Reference

Page: 261 / 608

Chapter 1: ColdFusion Tags 237
TABLENAME
Required. Name of the table you want to update. Note the following:
•
ORACLE drivers — This specification must be in uppercase.
•
Sybase driver — This specification is case-sensitive and must be in the same
case as that used when the table was created
TABLEOWNER
Optional. For data sources that support table ownership (for example, SQL Server,
Oracle, and Sybase SQL Anywhere), use this field to specify the owner of the table.
TABLEQUALIFIER
Optional. For data sources that support table qualifiers, use this field to specify the
qualifier for the table. The purpose of table qualifiers varies across drivers. For SQL
Server and Oracle, the qualifier refers to the name of the database that contains
the table. For the Intersolv dBase driver, the qualifier refers to the directory where
the DBF files are located.
USERNAME
Optional. If specified, USERNAME overrides the username value specified in the
ODBC setup.
PASSWORD
Optional. If specified, PASSWORD overrides the password value specified in the
ODBC setup.
PROVIDER
Optional. COM provider (OLE-DB only).
PROVIDERDSN
Optional. Data source name for the COM provider (OLE-DB only).
FORMFIELDS
Optional. A comma-separated list of form fields to update. If this attribute is not
specified, all fields in the form are included in the operation.
Example
<!--- This example shows the use of CFUPDATE to change
records in a data source --->
<!--- if course_ID has been passed to this form, then
perform the update on that record in the data source --->
<CFIF IsDefined("form.course_ID") is "True">
<CFUPDATE DATASOURCE="cfsnippets"
TABLENAME="courses" FORMFIELDS="course_ID,number,Descript">
</CFIF>
<!--- perform a query to reflect any updated information
if course_ID is passed through a url, we are selecting a
record to update ... select only that record with the
WHERE clause