I am trying to understand your problem. Is the name of the column being returned as 2 words or the value of the column being returned as two words?
Next question is what are you outputting to? Is this strictly in CF or are you using a Flashbuilder front end? If the name of the column is giving you problems, then in the stored procedure simply change the select and rename the field using the AS operator. Select [first name] AS firstName from people If you are using CF to get the results then shouldn't you use the an cfoutput/cfdump to get the data with the value you want wrapped in # signs? I use stored procedures and then use the cfprocresult to get the data into a variable that I can call from flashbuilder. HTH Jim -----Original Message----- From: Torrent Girl [mailto:[email protected]] Sent: Saturday, November 05, 2011 9:35 PM To: cf-newbie Subject: Re: columns with 2 words > >Don't know if this will work for you or not. > >(Depends on the database, too...) > > > >However, my first thought was concatenation. > > > >Some SQL like, select concat(last, name) as lastname. > > > >I'm sure that syntax isn't exactly correct, but a quick Google of > >concat sql and whatever db you're using will supply the syntax you > >need. > > > >hth, > > > >Rick > > > I guess I should have asked this: How do you output columns that consist of 2 words like 'First Name'? > You mean do the concat in my CF code? I am not understanding. The > column from the stored proc is in 2 words - First Name so I think a > concat will cause an error also. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5715 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
