#phasename#<br>
<cfoutput>
---#milestonename#<br>
</cfoutput>
</cfoutput>
----- Original Message -----
From: "Tangorre, Michael" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, October 20, 2003 8:25 AM
Subject: Grouped cfoutput
> I have a query whose result set looks like this:
>
> phaseId | phaseName | milestoneId | milestoneName
> --------------------------------------------------
> 1 phase1 1 name1
> 1 phase1 2 name2
> 1 phase1 3 name3
> 2 phase2 4 name4
> 2 phase2 5 name5
> 2 phase2 6 name6
> 3 phase3 7 name7
> 3 phase3 8 name8
> 3 phase3 9 name9
>
> I am trying to output the query so that in a table I can get the output to
> look like:
>
> Phase1
> ---name1
> ---name2
> ---name3
>
> Phase2
> ---name4
> ---name5
> ---name6
>
> Phase3
> ---name7
> ---name8
> ---name9
>
> The query I am using is as follows:
>
> SELECT
> P.phaseId,
> P.phaseName,
> M.milestoneId,
> M.nilestoneName
> FROM
> milestone M
> INNER JOIN phase P ON (M.milestonePhaseId = P.phaseId)
> ORDER BY
> P.phaseName
>
> How do I setup the cfoutput tags with the query and group attributes set
to
> obtain the output I described above..
>
> Thanks!
>
> Mike
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
