User Guide

252 Chapter 2: ColdFusion Tags
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.