You can probably do it very easily in CF5 using query-of-queries. Otherwise,
take a look at the Query Functions, such as QueryAddRow, etc. If you loop
through the CFRegistry query, you ought to be able to append those rows
right on to the end of the CFQuery query, one by one. Or store the results
in a new, third query.
Obviously query-of-query is the easiest and quickest (i would imagine)
solution, but unless you've got CF5, you're stuck with the manual way.
Norman
> -----Original Message-----
> From: JoshMEagle [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 08, 2001 11:02 AM
> To: CF-Talk
> Subject: How to combine queries
>
>
> This was originally part 2 of a 2 part question .... 1 was answered ...
>
> How do I combine 2 queries into one?
>
> I have a query from <CFREGISTRY> and one from <CFQUERY> ... I'd like to
> combine them into one query, say: qCombinedQuery so
> that I can use the output in the <cf_TWO_SelectsRelated> tag ...
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
