Neah... it's overrated. ..:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com
-----Original Message----- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 24, 2008 11:45 AM To: CF-Talk Subject: Re: Using Max Function on more that two data values Well, I guess if you want to _read_ and all. ;) On Wed, Sep 24, 2008 at 10:17 AM, s. isaac dealey <[EMAIL PROTECTED]> wrote: >> Actually MAX works in QofQ. I'd use that instead of maxrows: >> >> <cfquery name="foo" dbtype="query"> >> select max(something) as maxvalue from somequery >> </cfquery> > > Except that they wanted the max count and the name, not just the max > > -- > s. isaac dealey ^ new epoch > isn't it time for a change? > ph: 781.769.0723 > > http://onTap.riaforge.org/blog > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:313047 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
