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 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 6 rows of
>output like this:
>
>querya.row1: queryb.row1
>querya.row1: queryb.row2
>querya.row1: queryb.row3
>querya.row2: queryb.row1
>querya.row2: queryb.row2
>querya.row2: queryb.row3
>
>Instead I get:
>
>querya.row1: queryb.row1
>querya.row1: queryb.row2
>querya.row1: queryb.row3
>querya.row1: queryb.row1
>querya.row1: queryb.row2
>querya.row1: queryb.row3
>
>Thanks in advance.
>
>- Sean
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
