|
<CFINSERT DATASOURCE="ds_name
" TABLENAME="tbl_name" TABLEOWNER="owner" TABLEQUALIFIER="tbl_qualifier" FORMFIELDS="formfield1, formfield2, ...
">
CFINSERT inserts new records in ODBC data sources.
Attributes
DATASOURCE |
Required. Name of the ODBC data source that contains your table. |
TABLENAME |
Required. Name of the table you want the form fields inserted in. |
TABLEOWNER |
Optional. For data sources that support table ownership (such as SQL Server, Oracle, and Watcom SQL), use this field to specify the owner of the table. |
TABLEQUALIFIER |
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. |
FORMFIELDS |
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. |
Examples
<CFINSERT DATASOURCE="Coffee Valley" TableName="Visitor"> |