Try this
<cfset SubTotalTaxable = 0>
<cfloop query="taxableOrderItems">
<!--- notice there are no #'s in there --->
<cfset SubTotalTaxable = SubTotalTaxable + OrderTotal + ItemPrice>
</cfloop>
-----Original Message-----
From: Mark Leder [mailto:mel@;markleder.com]
Sent: Thursday, October 31, 2002 11:32 AM
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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
