Coldfusion Nested Cfloop or Cfloop within a Cfloop

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

1    <cfloop query="outerqueryset">
2        <cfloop query="innerqueryset">
3            <cfoutput>#outerqueryset.column1# #innerqueryset.column1#<br></cfoutput>
4        </cfloop>
5    </cfloop>

outerqueryset.column1 results in the first record's data being displayed regardless of current iteration in the outer loop.

Workaround

The workaround is to force the display of the current row, by accessing it via array.

1    <cfloop query="outerqueryset">
2        <cfloop query="innerqueryset">
3            <cfoutput>#outerqueryset.column1[outerqueryset.currentrow]# #innerqueryset.column1#</cfoutput>
4        </cfloop>
5    </cfloop

2 Responses to “Coldfusion Nested Cfloop or Cfloop within a Cfloop”

1. Jehiah

   May 30th, 2008

   you are welcome. I’m glad I was able to help save some time that would have otherwise been spent beating your head against the wall!

2. Bill

   May 30th, 2008

   Yep I did beat my head against the wall. Than came across your post. Couldn’t believe that the bug still existed in the latest version. Is this a feature of coldfusion? Dunno. But thanks for your help 🙂