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?
<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.
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>
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
AdChoices