MACROMEDIA COLDFUSION 4.5-CFML LANGUAGE, Reference

Page: 260 / 608

236 CFML Language Reference
CFUPDATE
The CFUPDATE tag updates existing records in data sources.
Syntax
<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.4.0.0 (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.
•
OLEDB —OLE DB provider. If specified, this database provider overrides the
driver type specified in the ColdFusion Administrator.
•
DB2 —DB2 5.2 native database driver.
•
Informix73—Informix73 native database driver.
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.