I've been searching but haven't found the answer. I have some nested loops
that cf doesn't seem to like- I've read about nested loops off their site,
but still haven't found the answer that is a little more involved...
I need to show data that loops through I think the best way to explain it
is to show it....
1st Query Main Topic shows here. There's only one Main Topic
1. 2ndQuery Output1- A subtopic of the Main Topic
a.1 3rd query linked to 2nd query (output1)
a.2. 3rd query link to 2nd query (output1)
b.1. 4th query linked to 2nd query (output1)
2. 2ndQuery Output2 A subtopic of the Main Topic
a.1 3rd query linked to 2nd query (output2)
a.2. 3rd query link to 2nd query (output2)
b.1. 4th query linked to 2nd query (output2)
b.3. 4th query linked to 2nd query (output2)
b.3. 4th query linked to 2nd query (output2)
3. 2ndQuery Output3 A subtopic of the Main Topic
a.1 3rd query linked to 2nd query (output3)
b.1. 4th query linked to 2nd query (output3)
b.2. 4th query linked to 2nd query (output3)
etc.
The best I have been about to do is show all the correct information for the
subtopics (1-3)of the Main Topics but can't get the a.1/b.1 to show the
correct data- it always just shows the data for the first one (2ndQuery
Output1)
This is how I set up the output :
<!---This is starting with the subtopics- the stems- these show
appropriately--->
<cfoutput QUERY="StemGet" Group="StemID">
#StemGet.Stem#
<BR>
<CFOUTPUT>
Interpretations:<BR>
<!---This shows any interpretations hooked to the stem subtopic-
This currently
only fills in with the interpretation data from the 1st subtopic.
Even if the heading shows the 3rd subtopic the interpretation shows from the
1st one. --->
<CFLOOP Query="InterpretationsGet">
#InterpretationsGet.Interpretation#<BR></CFLOOP>
<BR>
Benchmarks:<BR>
<!---Same problem as above--->
<CFLOOP Query="BenchmarksGet">
#BenchmarksGet.Benchmark#<BR> <!------>
</CFOUTPUT>
<BR>
</cfoutput>
Any help will be greatly appreciated. I'm feeling like I'm going in
circles- I can get the display to be correct only when I do it with one
subtopic per page, however, they need to all show on one page.
j
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Host with the leader in ColdFusion hosting.
Voted #1 ColdFusion host by CF Developers.
Offering shared and dedicated hosting options.
www.cfxhosting.com/default.cfm?redirect=10481
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
