O'Reilly logo

Programming ColdFusion by Rob Brooks-Bilson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

CFQUERY

Synopsis

<CFQUERY>
  [<CFQUERYPARAM>]
SQL statements
</CFQUERY>

Performs SQL operations against a data source or existing query object.

Attributes

NAME=" query_name "

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 SELECT 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.

DATASOURCE=" datasource_name "

The name of the data source to connect to when executing the query. Required except when DBTYPE is Query or Dynamic.

DBTYPE=" database_type "

The type of database driver to use. Optional. Possible choices are:

ODBC (the default)

Connect to the data source using an ODBC driver.

OLEDB

Connect using an OLEDB driver.

Oracle73

Connect using the Oracle 7.3 native driver. This requires the 7.3.4.0.0 or later client libraries be installed on the ColdFusion server.

Oracle80

Connect using the Oracle 8 native driver. This requires the 8.0 or later client libraries be installed on the ColdFusion server.

Sybase11

Connect using the Sybase 11 native driver. This requires the 11.1.1 or later client libraries be installed on the ColdFusion server.

DB2

Connect using the DB2 5.2 native driver.

Informix73 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required