Concerning the schema... I'm trying to merge the data from two different data providers' databases into one database. One provider has all remarks in a 'remarks' field and the second provider decided to divide their clients' remarks into four separate fields. (Don't know why they wanted to divide them up...)
I'm going to merge the remarks in the four separate fields into one 'remarks' field in my db. Does that seem appropriate? Rick > -----Original Message----- > From: Dawson, Michael [mailto:[EMAIL PROTECTED] > Sent: Monday, May 19, 2008 12:38 PM > To: CF-Talk > Subject: RE: How to combine multiple fields into one alias? > > After reading your original post, again, I think you may get quite a few > suggestions that you need to improve your database schema. > > If you have control over the database schema, you may be better of > storing your remarks in different records, rather than different fields. > In other words, store each remark in its own record, with an identifier > of the remark's "parent". > > m!ke > > -----Original Message----- > From: Dawson, Michael [mailto:[EMAIL PROTECTED] > Sent: Monday, May 19, 2008 11:32 AM > To: CF-Talk > Subject: RE: How to combine multiple fields into one alias? > > You need to "concatenate" the values. > > In DB2, you use ||. In SQL Server you use +. > > SELECT col1 || col2 AS newCol > SELECT col1 + col2 AS newCol > > I'm not sure about MySQL, but it should be similar. > > You might also find a CONCAT() database function with unlimited > arguments: > > SELECT CONTACT(col1, col2, coln) AS newCol > > m!ke ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305632 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
