Re: Nested output...three levels

2006-07-21 Thread Charlie Griefer 
i'll throw my hat into the ring too with a tutorial I did on grouping output:

http://tutorial150.easycfm.com/

:)

On 7/21/06, Jeff Small <[EMAIL PROTECTED]> wrote:
> Doug wrote:
> http://www.dougboude.com/blog/1/2006/07/IF-THE-SOLUTION-IS-NOT-BEAUTIFUL-THE
> N-IT-IS-WRONG--STYLE-ELEGANCE-AND-EFFICIENCY-IN-CODE.cfm
>
> Wow Doug, that's a terrific article. Thanks! I got it working and was doing
> everything right *except* I had just assumed (for some odd reason) that you
> couldn't nest the output the way I was nesting it. All I did was try it, and
> it worked.
>
> Thanks again.
>
>
>
> 

~|
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:247271
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Nested output...three levels

2006-07-21 Thread Jeff Small 
Doug wrote:
http://www.dougboude.com/blog/1/2006/07/IF-THE-SOLUTION-IS-NOT-BEAUTIFUL-THE
N-IT-IS-WRONG--STYLE-ELEGANCE-AND-EFFICIENCY-IN-CODE.cfm

Wow Doug, that's a terrific article. Thanks! I got it working and was doing
everything right *except* I had just assumed (for some odd reason) that you
couldn't nest the output the way I was nesting it. All I did was try it, and
it worked. 

Thanks again.



~|
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:247269
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Nested output...three levels

2006-07-20 Thread rhymes with 'loud' 
>This seems SOOO easy, and I'm about to kill myself.
>
The answer Kris gave is exactly right. 

Your first cfoutput told cf to output unique values of the first field. The 
second cfoutput told cf to output unique values of the second field. But a 
third cfoutput is required without a group attribute in order to output all of 
the child records of the second group.

I wrote a rather lengthy (but detailed) blog post about this very subject if 
you're interested in chewing on it; it may clear up some of the mud or even 
open some people's eyes to leveraging one of cfoutput's lesser used attributes.

http://www.dougboude.com/blog/1/2006/07/IF-THE-SOLUTION-IS-NOT-BEAUTIFUL-THEN-IT-IS-WRONG--STYLE-ELEGANCE-AND-EFFICIENCY-IN-CODE.cfm

~|
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:247254
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Nested output...three levels

2006-07-20 Thread Kris Jones 
It looks like you're missing your last cfoutput? Your final detail
piece wouldn't use a group attribute on the cfoutput. I'm just
guessing at the column name here, but something like this should work:

#qGetProcedures.Procedure1Title#
-#qGetProcedures.Procedure2Title#
--#qGetProcedures.Procedure3Title#



Cheers,
Kris

~|
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:247232
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Nested output...three levels

2006-07-20 Thread Andy Matthews 
I've never heard of a limit to nesting of CFOUTPUT. As long as all of the
outer ones have the group attribute you can nest as long as you like (I'm
sure there ARE limits, I just don't know them).



-Original Message-
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 20, 2006 12:08 PM
To: CF-Talk
Subject: RE: Nested output...three levels


Okay, why does this work?
#qGetProcedures.Procedure1Title#- #qGetProcedures.Procedure2Title#---
#qGetProcedures.Procedure3Title#

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:

#qGetProcedures.Procedure1Title#-
#qGetProcedures.Procedure2Title#

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:247214
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Nested output...three levels

2006-07-20 Thread Ian Skinner 
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? 

I don't know, One can nest as many s as one has fields in a query. 
 More then a few gets very cumbersome, but it is not illegal.


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
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:247213
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Nested output...three levels

2006-07-20 Thread Charlie Griefer 
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:
>
>  group="Procedure1ID">#qGetProcedures.Procedure1Title# group="Procedure2ID">-
> #qGetProcedures.Procedure2Title#
>
> 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

RE: Nested output...three levels

2006-07-20 Thread Jeff Small 
Okay, why does this work?
#qGetProcedures.Procedure1Title#- #qGetProcedures.Procedure2Title#---
#qGetProcedures.Procedure3Title#

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:

#qGetProcedures.Procedure1Title#-
#qGetProcedures.Procedure2Title#

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

RE: Nested output...three levels

2006-07-20 Thread Ian Skinner 
You did not show your code for the inner most cfoutput or how the output was 
failing.

So the only question I can ask is are you putting a group parameter on the 
innermost cfoutput?  One usually does not do this.  One usually just puts a 
plain #variousVariables# for the inner most 


--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

-
| 1 |   |
-  Binary Soduko
|   |   |
-
 
"C code. C code run. Run code run. Please!"
- Cynthia Dunning

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message. 




~|
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:247208
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Nested output...three levels

2006-07-20 Thread Jeff Small 
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:

#qGetProcedures.Procedure1Title#-
#qGetProcedures.Procedure2Title#

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