Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

CF mathmatics

New Here ,
May 31, 2019 May 31, 2019

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?

519
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Jun 02, 2019 Jun 02, 2019

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>

Translate
Community Expert ,
Jun 01, 2019 Jun 01, 2019

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 01, 2019 Jun 01, 2019

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. 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 01, 2019 Jun 01, 2019

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 01, 2019 Jun 01, 2019

<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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Jun 02, 2019 Jun 02, 2019

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>

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Jun 02, 2019 Jun 02, 2019
LATEST

That worked... Thanks!

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources