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
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
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
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 cfoutput#variousVariables#/cfoutput for the inner
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
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
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 cfoutput...s as one has fields in a query.
More then a few gets very cumbersome, but it is not illegal.
--
Ian
ICGLink, Inc.
[EMAIL PROTECTED]
615.370.1530 x737
--//-
-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?
cfoutput query=qGetProcedures
group
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:
cfoutput query=qGetProcedures
group=Procedure1ID#qGetProcedures.Procedure1Title#br
cfoutput
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
10 matches
Mail list logo
