>In your original query give the column an alias like > >SELECT [First Name] AS FirstName ... > >then in your QoQ use the alias (FirstName) to refer to the column. > >Azadi > > >>
The original is a stored proc. It retrieves the column names as two words because those are the column names used to create excel, tab and csv files, so I can't change that. So how do I select a column name with 2 words in a QoQ? What i want to do is this: <cfquery name="formattedData" dbtype="query"> Select First Name from query1 </cfquery> But of course this throws an error. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348493 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
