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.