User Guide

442 Chapter 2: ColdFusion Tags
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; “Creating an update action page with cfupdate” in Chapter 21, “Updating Your
Database,” in ColdFusion MX Developer’s Guide
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 the database that
contains the table
• Intersolv dBASE driver: directory of DBF files
username Optional Overrides
username value specified in ODBC setup.