if not, what about adding the values to an array, in the cfloop, then do
the ArraySum() function.

..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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Reply via email to