Duane wrote: > > Is it possible to return a record set that looks like: > UID Name Location > 1 Fred Main Office, Cafeteria > 2 Bob Gymnasium > 3 Mary Cafeteria
Not that I'm aware of. You'd have to either build a stored procedure or return the data like this: UID Name Location 1 Fred Main Office 1 Fred Cafeteria 2 Bob Gymnasium 3 Mary Cafeteria Then you could use coldfusion to organize tthings as you see fit. <table> <cfoutput query="qry" group="UID"> <tr><td>#uid#</td><td>#name#</td> <td><cfoutput><div>#location#</div></cfoutput></td> </tr> </cfoutput> </table> If you weren't looking to output it like that, but rather return it via a web service or something, you could use QueryNew() to create a result query, and use the same sort of code above to loop through, add rows, and set the query cells. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:215179 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
