Adding values in a recordset

[wycks]

Hi,

I have a recordset with some values in it that I want to add together but I don't know how to do it.  The recordset looks like:

<cfquery name="rsResults" datasource="username" username="value" password="F00tBall">

SELECT *

FROM options

WHERE value_id = '#FORM.value_id#'

</cfquery>

I list the values in a table

<cfoutput query="rsResults">

#rsResults.value#,

</cfoutput>

and I want to add together all the values and display the result but I don't know how to do that.  Can anyone help with this?

Thanks,Mike

[wycks · Accepted solution]

I found the answer myself.  I used

<cfset total = ArraySum(rsResults['value'])>