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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists