Use the AVG aggregate function. I think you really need to take a step back from what you're doing and spend some time learning basic SQL, because a huge number of the issues you've been posting about would be immediately solved if you had an understanding of joins and aggregate functions. There are literally thousands of web sites and books that will explain SQL so I'd start there.
On Mon, Apr 21, 2008 at 10:00 AM, erik tom <[EMAIL PROTECTED]> wrote: > >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:303932 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
