Should be double quotes I think
Select SUM("1990")
Some DBs use brackets too I think
sum([1990])
Not sure how it would work undr the hood with query of query, can't you
pull this from the db directly?
On Wed, 2010-06-09 at 11:27 -0400, fun and learning wrote:
> HI All -
>
> I have a query which returns the result set like below. The column names are
> like 1990, 1991, 1992 and there are certain amount for each year
>
> 1990 1991 1992
> 1000 5000 6000
> 2000 2000 3000
>
> I have a query of query which finds the sum of the amounts for year 1990, and
> I use the query like Select SUM(1990), it returns the sum of 1990+1990. How
> to make sure that 1990 is recognized as a column instead as a number.
>
> Thanks
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:334409
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
