<CFUPDATE DATASOURCE="ds_name"
DBTYPE="type"
DBSERVER="dbms"
DBNAME="database name"
TABLENAME="table_name"
TABLEOWNER="name"
TABLEQUALIFIER="qualifier"
USERNAME="username"
PASSWORD="password"
PROVIDER="COMProvider"
PROVIDERDSN="datasource"
FORMFIELDS="field_names">
DATASOURCE
Required. Name of the data source that contains your table.
DBTYPE
Optional. The database driver type:
- ODBC (default) -- ODBC driver.
- Oracle73 -- Oracle 7.3 native database driver. Using this option, the ColdFusion Server computer must have Oracle 7.3.3 (or greater) client software installed.
- Oracle80 --Oracle 8.0 native database driver. Using this option, the ColdFusion Server computer must have Oracle 8.0 (or greater) client software installed.
- Sybase11 --Sybase System 11 native database driver. Using this option, the ColdFusion Server computer must have Sybase 11.1.1 (or greater) client software installed. Sybase patch ebf 7729 is recommended.
DBSERVER
Optional. For native database drivers, 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 only). If specified, DBNAME overrides the default database specified in the data source.
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.
|