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/
