Nested Loops (query)

2001-10-03 Thread Sean Daniels
OK, I feel like I've done this before, but maybe not. Can anyone explain to me how to do this and get my desired result. cfloop query=querya cfloop query=queryb #querya.val#: #queryb.val# /cfloop /cfloop What I want is, if querya had 2 rows and queryb had 3 rows, to get

Re: Nested Loops (query)

2001-10-03 Thread John Paitel
Reverse your loops: cfloop query=queryb cfloop query=querya #querya.val#, #queryb.val# /cfloop /cfloop John At 04:24 PM 10/3/01 -0400, you wrote: OK, I feel like I've done this before, but maybe not. Can anyone explain to me how to do this and get my desired

RE: Nested Loops (query)

2001-10-03 Thread Andrew Tyrone
: Wednesday, October 03, 2001 5:36 PM To: CF-Talk Subject: Re: Nested Loops (query) Reverse your loops: cfloop query=queryb cfloop query=querya #querya.val#, #queryb.val# /cfloop /cfloop John At 04:24 PM 10/3/01 -0400, you wrote: OK, I feel

RE: Nested Loops (query)

2001-10-03 Thread John Paitel
This solution won't work. What is happening is that you are referring to only the first row in your inner cfloop, in regards to querya, which is why you are only getting the output of the first value in the first row. Reversing the process will simply reverse the output you are getting, not

Re: Nested Loops (query)

2001-10-03 Thread Bud
On 10/3/01, Sean Daniels penned: cfloop query=querya cfloop query=queryb #querya.val#: #queryb.val# /cfloop /cfloop This will work: cfloop query=querya cfset querya_value = val cfloop query=queryb CFOUTPUT#querya_value#: #val#br/CFOUTPUT