User Guide

cfquery 347
ColdFusion MX:
• Changed Query of Queries behavior: it now supports a larger subset of standard SQL.
• Changed dot notation support: ColdFusion now supports dot notation within a record set
name. ColdFusion interprets such a name as a structure.
• Deprecated the connectString, dbName, dbServer, provider, providerDSN, and sql
attributes, and all values of the
dbtype attribute except query. They do not work, and might
cause an error, in releases later than ColdFusion 5.
• New query object variable: cfquery.ExecutionTime.
• No longer supports native drivers. It now uses JDBC (and ODBC-JDBC bridge) for database
connectivity.
Attributes
Attribute Req/Opt Default Description
name Required Name of query. Used in page to reference query record set.
Must begin with a letter. Can include letters, numbers, and
underscores.
dataSource Required
unless
dbtype=query.
Name of data source from which query gets data. You must
specify either
dbtype or dataSource.
dbtype Optional Use this value to specify the results of a query as input. You
must specify either
dbtype or dataSource.
username Optional Overrides username in data source setup.
password Optional Overrides password in data source setup.
maxRows Optional -1 (All) Maximum number of rows to return in record set.
blockFactor Optional 1 Maximum rows to get at a time from server. Range: 1 - 100.
Might not be supported by some database systems.
timeout Maximum number of seconds that each action of a query is
permitted to execute before returning an error. The
cumulative time may exceed this value.
For JDBC statements, ColdFusion sets this attribute. For
other drivers, check driver documentation.
cachedAfter Optional Date value (for example, April 16, 1999, 4-16-99). If date of
original query is after this date, ColdFusion uses cached
query data. To use cached data, current query must use
same SQL statement, data source, query name, user name,
password.
A date/time object is in the range 100 AD–9999 AD.
When specifying a date value as a string, you must enclose
it in quotation marks.