Chapter 7


A1:

A, and B. dbtype is an attribute of the <cfquery> tag that is used to specify the type of query, and executionTime is not in the query object (it is returned as cfquery.executionTime).

A2:

C. Although the <cfoutput> group attribute can be used in conjunction with SQL GROUP BY operations, <cfoutput> GROUP and GROUP BY are not related (the latter is used when performing aggregate calculations).

A3:

D. Query of queries requires a NAME attribute to reference the resulting query variable and dbtype="query" to instruct ColdFusion to look for table names in available query variables.

A4:

A, B, C, and D. Any SQL statement can be passed to the database by using <cfquery>, provided that the designated driver can handle it.



Macromedia ColdFusion MX 7 Certified Developer Study Guide
Macromedia ColdFusion MX 7 Certified Developer Study Guide
ISBN: 0321330110
EAN: 2147483647
Year: 2004
Pages: 389
Authors: Ben Forta

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net