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> 

Comments

Popular posts from this blog

PHPMotion implementation - URL based videos (Hosted on separate location) -

javascript - Using Windows Media Player as video fallback for video tag -

c# - Unity IoC Lifetime per HttpRequest for UserStore -