coldfusion - Looping over the query results set -

i checking work geting query result as:

query     value 1   #ff6600,#339933,#0033cc,#ff0000,#00cc66,#ff9900,#ffff00,#00ffff,#ff66ff 2   open, resolved, in-progress, escalated, closed, re-opened,rejected,on-hold,locked 

now need map 1st row parrallel value 2row, know can done via cfloop or should convert array..

need nested loops, not sure how work

please guide

something should work data in question.

<cfset numberofitems = listlen(queryname.value[1])> <cfoutput> <cfloop from=1 to=numberofitems index=idx> row 1 item #listgetat(queryname.value[1], idx)#<br> row 2 item #listgetat(queryname.value[2], idx)#<br> </cfloop> </cfoutput>