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/
