This seems SOOO easy, and I'm about to kill myself.
Here's what I want (this is just sample data from my tables to give you an
idea):
Candy
- Gums
- Bubble Gum
- Spearmint Gum
- Hard Candies
- Jolly Rancher
Snacks
- Chips
- Doritos
- Potato Chips
I have three tables. I have the Query working perfectly joining all three.
But it's my output that's KILLING me. I can get two levels out using the
group clause on each level's ID:
<cfoutput query="qGetProcedures"
group="Procedure1ID">#qGetProcedures.Procedure1Title#<br><cfoutput
group="Procedure2ID">-
#qGetProcedures.Procedure2Title#<br></cfoutput></cfoutput>
But at that third level ("Bubble Gum, Spearmint Gum") I can't get any
output. I can only nest two cfoutputs like that.
What am I overlooking? How do I get the output for my query? I just KNOW
this is easy, but believe it or not, I've actually never done it. It's
deceptively recursive, and I'm just stumped!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:247205
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
