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: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234306 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
