Select avg(columnname) as whatever from table ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com
-----Original Message----- From: erik tom [mailto:[EMAIL PROTECTED] Sent: Monday, April 21, 2008 10:01 AM To: CF-Talk Subject: Re: output column average using coldfusion >I have to point out that this approach is terribly inefficient. Calculations >like this should be in at the database level using SQL, that's exactly what >it's supposed to do. Any time you're looping over queries to run more >queries, or to total things up, it should be a big red flag, because in >almost every situation the same thing can be done in SQL more easily and far >more quickly. > >On Fri, Apr 18, 2008 at 3:36 PM, erik tom <[EMAIL PROTECTED]> wrote: > >> How can i accomplish this ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303861 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
