User Guide

cfupdate 355
cfupdate
Description
Updates records in a data source from data in a ColdFusion form or form Scope.
Category
Database manipulation tags
Syntax
<cfupdate
dataSource = "ds_name"
tableName = "table_name"
tableOwner = "name"
tableQualifier = "qualifier"
username = "username"
password = "password"
formFields = "field_names">
See also
cfinsert, cfprocparam, cfprocresult, cfquery, cfqueryparam, cfstoredproc,
cftransaction
History
ColdFusion MX: Deprecated the connectString, dbName, dbServer, dbtype, provider and
providerDSN attributes. They do not work, and might cause an error, in releases later than
ColdFusion 5.
Attributes
Attribute Req/Opt Default Description
dataSource Required Name of the data source that contains the table.
tableName Required Name of table to update.
• For ORACLE drivers, must be uppercase.
• For Sybase driver: case-sensitive; must be in same case
as used when the table was created
tableOwner Optional For data sources that support table ownership (for
example, SQL Server, Oracle, Sybase SQL Anywhere),
the table owner.
tableQualifier Optional For data sources that support table qualifiers. The purpose
of table qualifiers is as follows:
• SQL Server and Oracle: name of database that contains
table
• Intersolv dBASE driver: directory of DBF files
username Optional Overrides
username value specified in ODBC setup.
password Optional Overrides
password value specified in ODBC setup.
formFields Optional (all on
form,
except
keys)
Comma-delimited list of form fields to update.
If a form field is not matched by a column name in the
database, ColdFusion throws an error.
The formFields lies must include the database table
primary key field, which must be present in the form. It can
be hidden.