cfinsert

Overview ColdFusion Open BlueDragon Lucee

Inserts records in data sources from data in a CFML form or form Scope.

Attributes

Name Required Type Default Description
10
clientinfo No Struct Contains clientinfo properties to be set on the database connection
datasource Yes String Data source; contains table.
8
dbname No String Deprecated
8
dbserver No String Deprecated
8
dbtype No String Deprecated
10
fetchclientinfo No Boolean Flag to indicate if clientinfo properties should be added to the result variable
formfields No String Comma-delimited list of form fields to insert. If not specified, all fields in the form are included. If a form field is not matched by a column name in the database, CFML throws an error. The database table key field must be present in the form. It may be hidden.
password No String Overrides password specified in ODBC setup.
8
provider No String Deprecated
8
providerdsn No String Deprecated
tablename Yes String Table in which to insert form fields. ORACLE drivers: must be uppercase. Sybase driver: case-sensitive. Must be the same case used when table was created
tableowner No String 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 No String For data sources that support table qualifiers, use this field to specify qualifier for table. The purpose of table qualifiers varies among drivers. For SQL Server and Oracle, qualifier refers to name of database that contains table. For Intersolv dBASE driver, qualifier refers to directory where DBF files are located.
username No String Overrides username specified in ODBC setup.