Well you had been on the right track there as well, the problem would have lied in the SQL then. There are maybe a few ways to do it, but you could certainly have a total or running total with SQL that resets when the indicated field changes.
I think one of the things you might walk away with here, is that anything can be done in SQL. The thing to decide is whether you need to increase performance of your webserver, or portability of your application across other DB's. Or it just doesn't matter, most of the smaller sites, developers might opt for the server doing the grouping, as they don't ever foresee the site needing that level of performance gain. -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411<http://plus.google.com/108193156965451149543> On Mon, Oct 1, 2012 at 4:05 PM, Chester Austin <[email protected]>wrote: > > Thanks. That was just the final mental push I needed. I knew it had to > do something with that, but I just couldn't get it out. I was really over > thinking it by trying to do a rollup on the query. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352790 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
