Query of Queries user guide

The following sections discuss Query of Queries functionality. If you know SQL or have interacted with databases, you might be familiar with some of these features.

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.

Comments

Buckshot2 said on Feb 10, 2004 at 7:49 PM :

I'm looking for a more comprehensive overview of QoQ functionality.

halL said on Feb 11, 2004 at 5:30 AM :

In LiveDocs, the pages that preceded and follow this one provide the most comprehensive documentation on Query of Queries available in the standard ColdFusion Documentation set. Click the arrows on the pages to view a series of topics on queries of queries. The first topic in the series is at http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_r6.htm.

The PDF version of the Developers Guide or the HTML version of the documentation that is installed with ColdFusion are easier to navigate than LiveDocs. To view the local HTML version or get the PDF version, click the Documentation link at the very top of the ColdFusion MX Administrator.
This navigation problem with LiveDocs is a known issue that we intend to addresss.

If you need additional information on queries of queries, I'd suggest that you check out the ColdFusion developer's center at http://www.macromedia.com/devnet/mx/coldfusion/.

Buckshot2 said on Feb 11, 2004 at 1:52 PM :

thanks hal ..

No screen name said on Mar 9, 2005 at 9:29 AM :

Can Query Of Queries in ColdFusion support subqueries?

For example i have 2 master queries that obtain all the data i need. But i also have another query that queries both queries using subquries but i keep getting an error each time i try to use one query within another. ( I tried using IN but it doesn't make a difference.)
---------------------------------My Error:-----------------------
Query Of Queries syntax error.
Encountered "itemID = ( Select" at line 0, column 0. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,

Database

Database Error:

select description from QyMydatalist2 where FD = (param 1) and listID = (param 2) and itemID = (Select value from QyMydata where RID = (param 3) and FD = (param 4) )

jrunrandy said on Mar 14, 2005 at 1:58 PM :

Sorry. Subqueries are not supported in a Query of Queries.


Contents > Developing ColdFusion MX Applications > Using Query of Queries > Query of Queries user guide