Although I believe that there are lots of reason why you should do this in the db (outlined in my last mail regarding this) , if you are using XML and you want to do calculations, its very easy in XSLT or using the cf XML functions ..
for example to sum up subtotals in invoices the xPath function sum(/customer/invoice/subtotal) does the trick WG > Although xml is the proper way to display data, I need to calculate data. > I'm still working on it. If I come up with anything (hopefully) > I'm going to > post it to the forums. > > Thanks everyone, > Mahmut ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4