Sorry, disregard my answer, it has been answered already and my solution is incorrect
On 11/6/2011 12:41 PM, Rex wrote: > I posted an answer to this in CF-Newbie, sorry for the cross-post. > > In the QoQ, wrap the column name in single-quotes. Only tried in > CF9+MSSQL, but it 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-talk/message.cfm/messageid:348489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm