Yes Bert... I discovered that in my attempts
Thanks for sharing that
Tim
-Original Message-
From: Bert Dawson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 19, 2003 7:35 AM
To: CF-Talk
Subject: RE: nesting output from 2 queries
One "feature" of nesting you should be a
Thanks to all that replied ...I ended up not having to do the nested
loop scenario, but now at least I know that capability is there
-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 3:15 PM
To: CF-Talk
Subject: RE: nesting output from 2
One "feature" of nesting you should be aware of is that if you reference the outer query from inside the inner query it will always return the first row:
#query1.myCol#
#query1.myCol# <--- this will always be row 1 of query1, i.e #query1.myCol[1]# --->
#query2.myC
The simplest fix to your posted code is to use the cfloop tag for at least
one of the queries. Cfloop tags can be nested.
SELECT fields_various
FROM table1
/cfquery>
SELECT columns_various
FROM table2
#fields_various#
#columns_various#
Now when you start to nest queries, the auto
Sure...see below:
>
> SELECT fields_various
> FROM table1
> /cfquery>
>
>
> SELECT columns_various
> FROM table2
>
>
>
>
>
> #fields_various#
>
>
> #columns_various#
>
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Replace one (or both) your with
-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 quer
6 matches
Mail list logo