Adding values in a recordset
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
