Skip to main content
Inspiring
February 26, 2019
Answered

Adding values in a recordset

  • February 26, 2019
  • 1 reply
  • 442 views

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

    This topic has been closed for replies.
    Correct answer wycks

    I found the answer myself.  I used

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

    1 reply

    wycksAuthorCorrect answer
    Inspiring
    February 26, 2019

    I found the answer myself.  I used

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