User Guide

cfinsert 205
cfinsert
Description
Inserts records in data sources from data in a ColdFusion form or form Scope.
Category
Database manipulation tags
Syntax
<cfinsert
dataSource = "ds_name"
tableName = "tbl_name"
tableOwner = "owner"
tableQualifier = "tbl_qualifier"
username = "username"
password = "password"
formFields = "formfield1, formfield2, ...">
See also
cfprocparam, cfprocresult, cfquery, cfqueryparam, cfstoredproc, cftransaction,
cfupdate
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 Data source; contains table.
tableName Required Table in which to insert form fields.
ORACLE drivers: must be uppercase.
Sybase driver:case-sensitive. Must be the same case used
when table was created
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 qualifier for table. The purpose of table qualifiers varies
among drivers. For SQL Server and Oracle, qualifier refers to
name of database that contains table. For Intersolv dBASE
driver, qualifier refers to directory where DBF files are located.
username Optional Overrides username specified in ODBC setup.
password Optional Overrides password specified in ODBC setup.
formFields Optional (all on
form,
except
keys)
Comma-delimited list of form fields to insert. If not specified,
all fields in the form are included.
If a form field is not matched by a column name in the
database, ColdFusion throws an error.
The database table key field must be present in the form. It
may be hidden.