Performs SQL operations against a data source or existing query object.
Name to assign to the query. Valid query names must begin with a
letter and can contain only letters, numbers, and underscore
characters. Required when passing an SQL
statement; optional for all other SQL operations. Although the
NAME attribute is required only for SQL
SELECT statements, you may wish to use it in all
your queries. It makes debugging easier, especially for templates
that contain multiple queries because it allows you to identify each
query by name in the debugging output.
The name of the data source to connect to when executing the query.
Required except when
The type of database driver to use. Optional. Possible choices are:
Connect to the data source using an ODBC driver.
Connect using an OLEDB driver.
Connect using the Oracle 7.3 native driver. This requires the 22.214.171.124.0 or later client libraries be installed on the ColdFusion server.
Connect using the Oracle 8 native driver. This requires the 8.0 or later client libraries be installed on the ColdFusion server.
Connect using the Sybase 11 native driver. This requires the 11.1.1 or later client libraries be installed on the ColdFusion server.
Connect using the DB2 5.2 native driver.