Thansk! That answers my question.
best, paul
At 05:27 PM 5/7/01 -0700, you wrote:
>Heh, not much to explain about it. On the easiest level just match the ORDER
>BY clause in the SQL statement w/ the grouping levels.
>
>[SQL statement]
>....
>ORDER BY field1, field2, field3, .. fieldn
>;
>
>
>[CF output]
><cfoutput query="foo" group="field1">
>Stuff every time new value in field1.
>
> <cfoutput query="foo" group="field2">
> Stuff every time new value in field2.
>
> <cfoutput query="foo" group="field3">
> Stuff every time new value in field3.
> </cfoutput>
>
> </cfoutput>
>
></cfoutput>
>
>
>
>-----Original Message-----
>From: Paul Smith [mailto:[EMAIL PROTECTED]]
>Sent: May 7, 2001 17:01
>To: CF-Talk
>Subject: CFOUTPUT & GROUP
>
>
>Hello!
>
>Is there a good tutorial somewhere on the Subject?
>
>I need to group more than one level down and the subject of grouping always
>hurts my head ;-)
>
>Project Category 1
> Project Type 1
> Project 1
> Project 2
> etc
> Project Type 2
> Project 89
> etc
>
>Project Category 2
> Project Type 7
> Project 3
>
>etc.
>
> best, paul
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
