#qTest.phaseName#<br>
<cfoutput>
---#qTest.milestoneName#<br>
</cfoutput>
<br>
</cfoutput>
Pascal
-----Original Message-----
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: maandag 20 oktober 2003 15:25
To: CF-Talk
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]
