-----Original Message-----
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 12:08 PM
To: CF-Talk
Subject: nesting output from 2 queries
If you have two different queries and you want to put the output of one
of those queries within the other, is that possible, if so how (group
processing doesn't appear to be an option)? Such as:
<cfquery datasource="DSN" name="query1">
SELECT fields_various
FROM table1
/cfquery>
<cfquery datasource="DSN" name="query2">
SELECT columns_various
FROM table2
</cfquery>
<cfoutput query="query1">
#fields_various#
<cfoutput query="query2">
#columns_various#
</cfquery>
</cfoutput>
TIA
Tim
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
