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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists