Ah!  That is it!

Thanks!



-----Original Message-----
From: Phillip Ciske [mailto:[EMAIL PROTECTED] 
Sent: Monday, March 10, 2008 1:49 PM
To: CF-Talk
Subject: Re: adding query results

> I swear I remember a CF function that would total a query's results.
>
> Like if my query returns 10 rows of grandTotal and grandTotal is a field that 
> contains numbers.
>
> You could run a function and it would add the 10 rows together so you get one 
> number.

ArraySum?

total = arraySum(yourQuery['grandTotal'])



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300871
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to