What database are you running? Things like this are much better left to the database than the web server. For example, on Oracle I'd write a stored procedure to calculate and return each report's data, then use CF/Flex to show the resulting data. Or I'd make an Oracle view, depending on how complex the query is. It's is amazing what you can do with good query optimization and use of the inherent features found in the database. I do things in Oracle I would never attempt with CF and do them efficiently and fast. I can't remember the last time I wrote an actual query in CF -- almost everything is stored procedures.
You can also set up the database to do an increment like you want using triggers, etc. My caution there is that an e-commerce site often needs blazing speed and you'll want to do a lot of testing to be sure you don't slow it down. If you have the knowledge and access to the database, I strongly recommend you let the db handle the data crunching and CF handle the output of the data. Warren Koch ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299787 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
