|
| Components | Databases | NAS | Links
Search the Workbench:
|
|
Description: <CFQuery> submits SQL statements to an ODBC driver. SQL statements are not limited to SELECT statements, but can also be INSERT, UPDATE, and DELETE statements, as well as calls to stored procedures. Cold Fusion conditional code may be used between the <CFQuery> and </CFQuery> tags, allowing you to create dynamic SQL statements.
Syntax:
<CFQuery NAME = “Parameter Name” DATASOURCE = “ODBC Data Source” DBNAME = “database name” DBPOOL = “pool” DBTYPE = “type” DBSERVER = “dbms” USERNAME = “User Name” PASSWORD = “Password”
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