Inserts records in data sources.
This tag can't have a body.
<cfinsert [datasource="string"] [formfields="string"] [password="string"] tablename="string" [tableowner="string"] [tablequalifier="string"] [username="string"]>
The attributes for this tag are fixed. Except for the following attributes no other attributes are allowed.
|datasource||string||No||Name of the data source that contains your table.|
|formfields||string||No||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||No||If specified, password overrides the password value specified in the ODBC setup.|
|tablename||string||Yes||Name of the table you want the form fields inserted in.|
|tableowner||string||No||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||string||No||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.
|username||string||No||If specified, username overrides the username value specified in the ODBC setup.|