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">
WHERE value_id = '#FORM.value_id#'
I list the values in a table
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?
I found the answer myself. I used
<cfset total = ArraySum(rsResults['value'])>