Okay, why does this work? <cfoutput query="qGetProcedures" group="Procedure1ID">#qGetProcedures.Procedure1Title#<br><cfoutput group="Procedure2ID">- #qGetProcedures.Procedure2Title#<br><cfoutput group="Procedure3ID">--- #qGetProcedures.Procedure3Title#<br></cfoutput></cfoutput></cfoutput>
I never knew you could nest three levels of cfoutput. Why on earth was I thinking you could only set ONE cfoutput inside another one? -----Original Message----- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Thursday, July 20, 2006 12:57 PM To: CF-Talk Subject: Nested output...three levels 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:247210 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
