JavaScript | Actions | CSS | Documentation |
  | Components | Databases | NAS | Links

Search the Workbench:

Description: CFInsert adds a single row to a database table. CFInsert requires that the database and table names be provided.

Syntax:
<CFINSERT DATASOURCE = “ODBC Data Source” FORMFIELDS = “List of File to Insert” TABLENAME = “Table Name” TABLEOWNER = “owner” TABLEQUALIFIER = “qualifier”>

What the CFInsert component editor looks like.

CFInsert Attributes

Attribute

Description

Notes

Datasource

Name of the ODBC data source

Required; the specified data source must already exsit.

Formfields

List of fields to insert

Optional; specifies which fields are to be inserted if they are present.

Tablename

Name of table to insert data into

Required

Tableowner

Table owner name

Optional

Tablequalifier

Table qualifier

Optional

Example:
<CFINSERT DATASOURCE = “A2Z” TABLENAME = “Employees” FORMFIELD = “LastName,FirstName,PhoneNumber”>

Note: Your form field names must match the column names in the destination table for <CFInsert> to work correctly.

Go Back to Previous Page

Have a question that you can´t find the answer to? Want to report a possible bug?

Send a help request to NetObjects Technical Support