Coldfusion Cfloop within a cfloop or gives interesting results. I couldn’t believe it was a bug. But looks to be true once tested. Thanks to Blog of Jehiah Czebotar who bailed me out of this issue after looking at it for some time with eyes crossed and debugging.
Here is the summary from Jehiah blog post. Thanks Again Jehiah!
There is a bug in the processing of nested cfloop tags in Macromedia Cfloop ColdFusion MX, as the example below shows. I have developed a workaround for this which is also below.
Example of Problem
<cfloop query="outerqueryset"> <cfloop query="innerqueryset"> <cfoutput>#outerqueryset.column1# #innerqueryset.column1#<br></cfoutput> </cfloop> </cfloop>
â€˜outerqueryset.column1â€˜ results in the first recordâ€™s data being displayed regardless of current iteration in the outer loop.
The workaround is to force the display of the current row, by accessing it via array.
<cfloop query="outerqueryset"> <cfloop query="innerqueryset"> <cfoutput>#outerqueryset.column1[outerqueryset.currentrow]# #innerqueryset.column1#</cfoutput> </cfloop> </cfloop