User Guide

88 CFML Language Reference
DBSERVER
Optional. For native database drivers and the SQLOLEDB provider, specifies the
name of the database server machine. If specified, DBSERVER overrides the server
specified in the data source.
DBNAME
Optional. The database name (Sybase System 11 driver and SQLOLEDB provider
only). If specified, DBNAME overrides the default database specified in the data
source.
TABLENAME
Required. The 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
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.
TABLEOWNER
Optional. For data sources that support table ownership (such as 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.
PROVIDER
Optional. COM provider (OLE-DB only).
PROVIDERDSN
Optional. Data source name for the COM provider (OLE-DB only).
KEYONLY
Optional. Yes or No. Yes specifies that in the update action, the WHERE criteria is
confined to just the key values. No specifies that in addition to the key values, the
original values of any changed fields are included in the WHERE criteria. Default is
Ye s .