This content has been marked as final. Show 3 replies
For some reason, ColdFusion loses track of the query current row on the outside loop when you have an inside loop. To solve this, we wrote a custom tag, which we call duplicate_row, that creates a query with exactly one row, the current row of the outside loop. Then we use the new one row query in the inside loop. This works well, and the overhead is not tremendous.
I've attached the source for the custom tag.
It dosen't seem to be that complicated. Coldfusion does not loose track of the current row of the outside query loop. It is a scoping issue and you cannot reference the outer query loop in the same way. The code will work just fine if you append ([report.currentRow]) to the evaluate statement in the inner loop like this:
hey jmmorgan, thanks a lot. the only thing that i had to do was to use.
i'm such a better programmer now.
this was very easy to implement since i did not want to construct a query.
also thanks for your help mike