if there isnt a function in sql that can do that then there is a function on cflib to get a columntotal
http://cflib.org/udf.cfm?ID=887 so you can run that one query then pass the resulting column into the columnTotal udf and thats it, you will have the total surcharge... > 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:305369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
