So, it looks like column aliasing isn't valid in query of queries. For example, the following works:
select foo + ' - ' + foo2 from qry But this does not: select foo + ' - ' + foo2 as newfoo from qry Coldfusion seems to automatically alias the dynamic columns .. as "Column_1" in the case above. But.. is there any way to do column aliasing in QoQ that I'm missing, or is it just not supported? (BTW I'm using CFMX 7.0.2) -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285768 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
