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) >
Mmm... no, I aliased and "unaliased" (if that word exists) one by one all the columns in different combinations each time (in Group alone, in Group and CFoutput, in CFoutput alone, etc), and the only way it worked was to have all of them aliased. Like I said, the output of a ColumnList command yielded different values for each column on my desktop and on the server, but the aliases were interpreted exactly the same by both development and production servers (still waiting on the specs of the production one). Why the columns were being interpreted differently by DEV and PRO, that would be good to know. Roberto ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234314 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
