<cfinsert>

Inserts records in data sources.

This tag cannot have a body.

This tag is also supported within <cfscript>

Attribute Description
tablequalifier
string, optional

For data sources that support table qualifiers, use this field to specify the qualifier for the table. The purpose of table qualifiers varies across drivers. For SQL Server and Oracle, the qualifier refers to the name of the database that contains the table. For the Intersolv dBase driver, the qualifier refers to the directory where the DBF files are located.

tablename
string, required

Name of the table you want the form fields inserted in.

tableowner
string, 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.

formfields
string, optional

A comma-separated list of form fields to insert. If this attribute is not specified, all fields in the form are included in the operation.

password
string, optional

If specified, password overrides the password value specified in the ODBC setup.

datasource
string, optional

Name of the data source that contains your table.

username
string, optional

If specified, username overrides the username value specified in the ODBC setup.

<cfinsert
    [tablequalifier=string]
    tablename=string
    [tableowner=string]
    [formfields=string]
    [password=string]
    [datasource=string]
    [username=string]
>

Examples

There are currently no examples for this tag.

See also