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
