The CFINSERT tag is the easiest way to handle simple inserts from either a CFFORM or an HTML form.
In most cases, the optional attributes are not needed. The TABLEOWNER and TABLEQUALIFIER attributes are rarely necessary but are provided for compatibility with ODBC drivers that require you to specify a table owner and/or table qualifier. Neither of these fields needs to be specified for the Microsoft ODBC Desktop Drivers bundled with ColdFusion.
ODBC drivers that require table owners and/or qualifiers to be specified include all SQL Server and Oracle drivers, as well as all Intersolv Q&E drivers.
|