Thank you, this is exactly what I was looking for! josh
> -----Original Message----- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: Friday, July 25, 2003 10:58 AM > To: CF-Talk > Subject: Re: SOT: Strange SQL Question > > > Josh Remus wrote: > > Is it possible on a database with two tables in a one-to-many > relationship > > to grab the many and stick them all in one field? > > Create a custom aggregate function that concatenates them all. > See http://www.zope.org/Members/pupq/pg_in_aggregates > The example is for PostgreSQL, but any database that allows for > custom aggregate functions can do this. > > Jochem > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
