What is happening, you are getting the LAST record in the query to populate
the values.
What is it you are attempting??
If you want an Overall total of ItemPrice
Then is OrderTotal already defined?
If you are want to loop and continually add the values
until the end of the query is reached then you can
do something as follows:
<CFLOOP QUERY="taxableOrderItems">
<CFSET SubTotalTaxable = #SubTotalTaxable# + #OrderTotal# + #ItemPrice#>
</CFLOOP>
-----Original Message-----
From: Mark Leder [mailto:mel@;markleder.com]
Sent: Thursday, October 31, 2002 2:32 PM
To: CF-Talk
Subject: CFLoop query problem
Hi All,
I'm trying to loop through a query to add all the items contained in
that query.
This query set contains three records. When I do a CFOUTPUT inside the
CFLOOP on the ItemPrice field, all three individual prices are returned
in succession, but the <CFSET SubTotalTaxable> tag only shows the first
record. I want the tag to contain the sum of all three ItemPrice
fields. What am I doing wrong?
<cfset SubTotalTaxable = 0>
<!--- Loop the taxable products --->
<CFLOOP QUERY="taxableOrderItems">
<CFSET SubTotalTaxable = #OrderTotal# + #ItemPrice#>
</CFLOOP>
Thanks,
Mark
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
