Getting data from multiple rows into a list

[bika_123]

I have a table that has values as follows:
PersonID Degree
55 MD
55 Phd
55 RN
60 MD
60 Phd

I need a create a query that will give me output like this:

PersonID Degree
55 MD, Phd, RN
60 MD, Phd

Any ideas

[SaraGillie]

I would recommend using a cursor, loops and a temporary table. Here's some
pseudo code:



Retrieve all PersonIDs
Loop over each PersonID
Get all Degrees for PersonID
Create ListDegree variable
Loop over each Degree
Append Degree to the end of ListDegree
End Degree Loop
Insert PersonID, ListDegree into a temporary table
End PersonID Loop
Select records from temporary table

[Dan Bracuk]

Start with a simple query, ordering by personid. That gets you the output as
shown in the orginal post. Then do something like this:

<cfset thisid = 0>
<cfoutput query="yourquery">
<cfif personid is not thisid>
<br>#personid# <cfset thisid = personid>
</cfif>
&nbsp; #degree#
</cfoutput>