Incidentally, you can use [] to escape reserved words in query of queries. I've had to do that on a few occasions, and I made sure when I implemented my locale-specific query sorting function that it escaped the column names being passed in this way since I couldn't know that it wouldn't be used to sort on reserved words for query of queries.
> My guess is that "Region" is a reserved word *somewhere* > between CF, the OS, the web server...something. That's > probably why aliasing the field names fixed the problem. > In fact, I would bet that if you just aliased the region > field and grouped by it, it would STILL work on both your > dev box and the other. :0) > Doug :0) >>When you figure out the specs on the production server, be >>sure to post - >>because I've never had this problem and it this is a new >>issue with 7 (we're >>not there yet), we're going to be in for a world of hurt. >> >>On 3/4/06, Roberto Perez <[EMAIL PROTECTED]> wrote: s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234317 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
