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?
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.
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.
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.
<cfquery name="gcr" datasource="TCN">
WHERE BuyerName = 'NFLLC' and Packstyle = '18/8oz. Bags'
ORDER BY packstyle</cfquery>
I want to add all returned values for Quantity.
Following the query, use query-of-a-query:
<cfquery name="gcrQoQ" dbType="query">
SELECT SUM(quantity) as totalQuantity
That worked... Thanks!