Sorry, disregard my answer, it has been answered already in CF-TALK and my solution is incorrect
On 11/6/2011 12:37 PM, Rex wrote: > Torrent Girl, please correct me if I'm wrong, but this is my > understanding of your scenario: > > You have a stored proc that results in a query with a column called > [LAST NAME], which is a column with a space in it. You cannot change > this stored proc. > > Now when you do a QoQ on this query, and you do a SELECT [LAST NAME] > AS LASTNAME in the QoQ, CF errors out. > > Solution: In the QoQ, you wrap the column with single-quotes. This > works: > > <cfquery name="storedProcData" datasource="stuff1"> > SELECT 'this is data in the column' AS [COLUMN WITH SPACES IN THE > NAME] > </cfquery> > > <cfquery name="queryOfQueries" dbtype="query"> > SELECT 'COLUMN WITH SPACES IN THE NAME' AS COLUMNNAME FROM > storedProcData > </cfquery> > > <cfdump var="#storedProcData#"> > <cfdump var="#queryOfQueries#"> > > - Rex ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:5717 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
