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.