Hi all, Does anyone know, off the top of their heads, if a GROUP command in the output of a query of queries has server-specific issues?
I'm displaying the results of a query of queries using GROUP in the cfoutput tag: <cfoutput query="allRecords" group="region"> It works fine on my desktop (developer server, MX6), but when I upload that page to the server (MX6, don't know the OS) it throws this error: - - - - - - - - - Error Diagnostic Information Loop error The group region does not specify a column of the query - - - - - - - - - The query itself does not use group: <cfquery dbtype="query" name="allRecords"> SELECT listRegions.regionID, listRegions.regionNameAbbr, listRegions.region, listCities.regionID,listCities.cityID, listCities.cityName FROM listRegions, listCities WHERE listRegions.regionID = listCities.regionID ORDER BY listRegions.region ASC, listCities.cityID ASC </cfquery> Should the query of queries have the GROUP tag (although it works fine without it on my system)? Thanks in advance, Roberto Perez ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234170 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
