Try "col_alias = expression"
Mark
-----Original Message-----
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 6:17 PM
To: CF-Talk
Subject: query of queries and column aliasing
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285770
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
