You can carry a variable through your cfloop/cfoutput query to hold the running total of the surcharges. You can also hit the database with a new call for the sum, as other have mentioned.
You can also do: <cfset allsurcharges = ArraySum(ListToArray(ValueList([querycolumnname])))> William > Hi > > I am building a shopping cart which calculates shipping charges, some > products also have an additional surcharge. Which is where i am stuck, > > > The additional surcharge is stored within the product table. > > What i thought was to loop through the products in the cart, query > the products database to get the surcharge or surcharges, loop through > the query results for the individual surcharges. If this is the > correct way, how do i then add the surcharges up and account for when > the loop finishes. > > Jason > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4