mark.
can u use some sql logic here....like this....
<cfquery>
select Sum(ItemPrice) as OrderTotal from Blah......
</cfquery>
..tony
Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337
-----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
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
