Your query output is acually an array, so something like this works:

<cfscript>
YourSum = arraySum(YourQuery["YourField"]);
</cfscript>

The same thing with <cfset> may also work, but I have never tried it.

*******************
I have query that returns approx 2500 records.  The fields are name,
address, amount due, interest etc.  At the bottom of my display page I
would like to add up all the values in the amount due, and add up all the
interest amounts etc.

I have done math on two or three variables but never on so many values. Can
anyone point me in the right direction.

-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: [EMAIL PROTECTED]
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)

Reply via email to