Sams Teach Yourself ColdFusion® in 21 Days

CFINSERT

CFINSERT inserts new records in data sources.

Syntax

<CFINSERT DATASOURCE="ds_name"
    DBTYPE="type"
    DBSERVER="dbms"
    DBNAME="database name"
    TABLENAME="tbl_name"
    TABLEOWNER="owner"
    TABLEQUALIFIER="tbl_qualifier"
    USERNAME="username"
    PASSWORD="password"
    PROVIDER="COMProvider"
    PROVIDERDSN="datasource"
    FORMFIELDS="formfield1, formfield2, ...">

DATASOURCE

Required. Name of the data source that contains your table.

DBTYPE

Optional. The database driver type:

• ODBC (default) — ODBC driver.

• Oracle73 — Oracle 7.3 native database driver. Using this option, the ColdFusion Server computer must have Oracle 7.3.4.0.0 (or greater) client software installed.

• Oracle80 —Oracle 8.0 native database driver. Using this option, the ColdFusion Server computer must ...