CF mathmatics

[johng58900177]

Need a bit of assistance.  I have a client who manually creates a report t the end of each year that consists of poundage of every product per customer.  A customer may buy 50K lbs of different products each year.  Is there a way that I can add anywhere from 2 to 1000 different numbers together by outputting the data into a cfset tag or something else?

[BKBK]

Are the numbers coming from a column in a database table? If so, use the cfquery tag to construct a query that reads the values from the database. Then add the values in the query.

[johng58900177]

The numbers would come from a column.  I am not sure how many rows will be returned and I am about 3 weeks into coding cfml again after a 12 year hiatus. 

[BKBK]

No problem. Welcome back to ColdFusion!

It would help if you could write a query that gets all the orders within a period of time, for a given customerID. Bring the query to the forum for discussion.

[johng58900177]

<cfquery name="gcr" datasource="TCN">

SELECT *

FROM purchaseordertable

WHERE BuyerName = 'NFLLC' and Packstyle = '18/8oz. Bags'

ORDER BY packstyle</cfquery>

I want to add all returned values for Quantity.

[BKBK · Accepted solution]

Following the query, use query-of-a-query:

<cfquery name="gcrQoQ" dbType="query">

    SELECT SUM(quantity) as totalQuantity

    FROM gcr

</cfloop>

<cfset quantityOrdered=gcrQoQ.totalQuantity>

[johng58900177]

That worked... Thanks!