what's the query look like? are you using ORDER BY Procedure1ID,
Procedure2ID? if you're going to group your output in CF you need to
remember to order by the columns on which you're grouping
(sorry if you've got this...but i've been bitten in the butt by it a
couple of times before forgetting to ORDER BY appropriately) :)
On 7/20/06, Jeff Small <[EMAIL PROTECTED]> wrote:
> 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:247209
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
