Add up data

[stevenfilip]

Hi All,

For example I have two colums

country | amount
------------------
usa | 10
uk | 21
usa | 19
usa | 2
uk | 12
usa | 11

Now I would like to output the total of a country
so that I would get :

usa 42
uk 33

How would I do something like that in Coldfusion?

Thanks!

 

[r937]

if your two columns are in a database table, use sql

select country, sum(amount)
from yourtable
group by country

rudy

 

[stevenfilip]

Hi,

Thanks!

Call me stupid, but how would I output this data?

 

[r937]

you would output it with a CFOUTPUT tag

oh, you should also give a column alias to the aggregate

<CFQUERY NAME=&quot;foo&quot;>
select country, sum(amount) as totalamt
from yourtable
group by country
</CFQUERY>

<CFOUTPUT QUERY=&quot;foo&quot;>
#country# #totalamt#
</CFOUTPUT>

rudy