> :huh?: Why would you expect an outer loop control variable to
> increment in the inner loop? It doesn't seem to make any sense to me.
This was the situation I was referring to...
With these records
Parents 1 2
Children 3,4 5,6
I would like / expect / anticipate this code
<CFLOOP QUERY="GetParents">
<CFLOOP QUERY="GetChildren">
<CFOUTPUT>#GetParents.ParentID# - #GetChildren.ChildID#<BR></CFOUTPUT>
</CFLOOP>
</CFLOOP>
to produce this result
1 - 3
1 - 4
2 - 5
2 - 6
It doesn't. What I've seen on several occasions is this:
1 - 3
1 - 4
1 - 5
1 - 6
To get the value of 2 on loops 3 and 4, I had to put this between the two
<CFLOOP QUERY...> lines
<CFSET variables.ParentID = GetParents.ParentID>
and inside the CFOUTPUT, replace #GetParents.ParentID# with
#variables.ParentID#
Maybe in the past I've written some dodgy code to produce this effect (I
don't have any code I can paste here to illustrate without *hours* of
digging) but I've heard other people saying they've seen the same thing too.
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopperuk
Telephone +44 (01744) 648650
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
