At 08:45 PM 3/3/2006, I myself wrote: >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 did more digging and this is what I found: when I do a ColumnList on my desktop, I get a list like this: cityID,cityID,cityName,region,region,regionID,regionID,regionNameAbbr (repeated items are both in ORDER and SELECT statements) When I upload the page to the server, I get each column referenced to the master queries, like this: listCities.cityID,listCities.cityName,listCities.regionID,listRegions.region, listRegions.regionID,listRegions.regionNameAbbr (no repeated items here) The full query of queries is below: <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> The difference on ColumnList output could explain why the GROUP parameter is not understood. However, if I use GROUP="listRegions.regionNameAbbr", a whole another set of error messages displays. Is there a way of converting "listRegions.regionNameAbbr" to "regionNameAbbr"? I tried an alias, but in the end, it would be the same thing (i.e., the alias would point back to the original master query) ... Thanks in advance for any ideas/suggestions, Roberto ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234187 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
