i think the best way would be to do this is directly through sql in one query. you can build a list with the ids of all the products the customer has selected, then in 1 query...
select surcharge from products where productid in(<cfqueryparam value="theListOfProductIds#" list="yes" cfsqltype="cf_sql_varchar">) and surcharge <> "" i am not sure but there must be a function in sql that adds up all the values in a column - maybe someone else can suggest it - but this sql statement then saves all the time that a loop would take and would just return the results where those products you have entered have a surcharge, then it is just a matter of adding it up. but as i said there must be a sql function you can use within this same function to do that > 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:305368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
