Yup. I got it. Thanks so much On Fri, Dec 12, 2008 at 8:19 PM, Jason Fisher <[email protected]> wrote: > There's not a function, but you can add them up as you loop over the query: > > <cfset sumAssonum = 0> > <cfoutput query="..."> > <cfset sumAssonum = sumAssonum + Assonum> > </cfoutput> > <cfoutput>SUM of Assonum is #sumAssonum#</cfoutput> > >><cfquery ....> >> select a.Dept, c.Assonum >> ............. >> group by a.Dept, c.Assonum >> </cfquery> >> >> I need to get the SUM of c.Assonum, but I can't do sum(c.Assonum ) in >> the sql (cfquery). >> What is the way to get the SUM of c.Assonum with cf function? >> >> Please advise. >> >> Thank you > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316728 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
