Thanks for the tips guys - it seems everyone's leaning towards a DB solution so I'm going to look into Barney's suggestion of using GROUP_CONCAT (I'm using MySQL)
Cheers, Baz -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cliff Meyers Sent: Tuesday, November 08, 2005 4:36 PM To: [email protected] Subject: Re: [CFCDev] Query: Turn column into a list And here are some techniques for Oracle: http://www.oracle-base.com/articles/10g/StringAggregationTechniques.php What DB are you using? ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
