>Ah, right QoQ can be bitchy. Can't you alias the column names in the initial >query? > >SELECT my1990 = [1990], my1991 = [1991] >or >SELECT [1990] as my1990 etc etc > >That way can reference them without any issues. > >P.S. 1990 and the like are absolutely horrible column names. > >On Wed, Jun 9, 2010 at 11:41 AM, fun and learning ><funandlrnn...@gmail.com>wrote: > >>
Thanks you all for the replies. Prepending a variable before the year helped me ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm