You'd think so, but it used to work in cf6.1. Like I said it must have been some kind of insantiy that made me do it that way originally, but it does raise an interesting questoin. Why did it even work before? ... you don't have to answer.
Jason On Thu, 10 Mar 2005 08:57:04 +1100, Steve Onnis <[EMAIL PROTECTED]> wrote: > The second query is valid sql, the first one isn't. You cant group by or > order by a column if its not in the select list > > Steve > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Sheedy > Sent: Thursday, March 10, 2005 8:19 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: CF7 migration issues > > Gavin, > I ran into a QoQ issue too. It was probably a problem with my original code. > > <cfquery name="q1" dbtype"query"> > SELECT COUNT(person_id) AS totalpeople > FROM getCountries > GROUP BY country > </cfquery> > > I could then output country and totalpeople. Don't ask me why this > worked or why I did it this way. > > In CF7 I had to include country in the select list > > <cfquery name="q1" dbtype"query"> > SELECT country, COUNT(person_id) AS total > FROM getCountries > GROUP BY country > </cfquery> > > Jeremy. > If you use Jrun with cfmx instances you should have no worries simply > deleting the cfmx server instance. Not sure about the stand alone > version, but since it all runs on top of jrun I imagine the only thing > you'd need to do is remove your cfmx windows service and delete the > cfusion directory. The uninstaller should do all this for you though. > > Jason Sheedy > www.voice.com.au > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
