This is something along the lines of what I was looking for. Now, is there a way to display the full array and have the totaled column as well?
Kind regards, Rick -----Original Message----- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Tuesday, October 19, 2010 4:26 PM To: cf-talk Subject: Re: Totaling items in a recordet The best way would be to sum() it in the query itself. Failing that you can get the list of values, set it to an array, then sum it. #arraysum(listtoarray(valuelist(query.column)))# On Tue, Oct 19, 2010 at 3:16 PM, Rick Sanders <r...@webenergy.ca> wrote: > > Hey all. I am pulling prices from a database and want to total them. Is > there a function like #total(query.column)# ? > > Kind Regards, > > > Rick Sanders > Webenergy Software > 902-401-7689 > http://www.webenergy.ca > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:338332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm