I would move this total logic to the actual query i.e. SQL which will be the most efficient IMHO.
HTH Qasim On 10/15/07, Ben Doom <[EMAIL PROTECTED]> wrote: > > I don't know about actual cycle efficiency, but arraysum(query['row']) > is what I use. Very good on typing efficiency. :-) > > --Ben Doom > > Toby King wrote: > > Hi there > > > > I have an application where I am outputing a number of sales figures for > a year for various departments. > > > > Basically the table that I am outputing is in this format: > > > > Dept July Aug Sep Oct Nov Dec Total > > A 23 24 20 18 15 50 150 > > B 20 20 20 20 20 20 120 > > C 10 10 10 10 10 10 60 > > Total xxx xxx xxx xxx xxx xxx xxx > > > > Basically I have not had any trouble creating the total for the end of > the row - I have created an array and just added to the array and then I get > the total. > > > > I am struggling with obtaining the total for the bottom of the columns. > > > > What would be the most efficient way to do this. > > > > Thanks in advance. > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4