Ahh... so I was wrong... :) there's COALLESCE() in SQL Server and apparently somebody created a function to do it in Oracle... awesome... wonder if it merits changes to my cms data structure...
> This was asked a few weeks ago on the SQL list ... here is the thread ... > http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=2 > 56 > &forumid=6&refresh=0 > Dan > -----Original Message----- > From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] > Sent: Thursday, September 12, 2002 12:13 PM > To: CF-Talk > Subject: OT - MS SQL help > Is it possible to join two tables, and have a list of keys returned from > one > of the tables as a column of a recordset? > tblOnePK | name > 1 | threeFriends > tableTwoPK | tblOneFK > 1 | 1 > 2 | 1 > 3 | 1 > And the record set should be: > tblOnePK | name | listOfKeys > 1 | threeFriends| 1,2,3 > Make sense? > I could do it programmatically in CF, but would like to pull this in one > query and avoid a recordset/requery loop. Also, can't use a stored proc, > unfortunately. > Thanks for any help. > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
