>You can say select url as myurl in the query, but yea, that's going to >require code changes... > >>
Yep, that would work for select, but any updates/inserts would probably be a real pain. I don't know what idiot named the field "URL", but I'm guilty of being the exact same kind of idiot myself in the past. Fortunately, that field is a VERY minor one; one that isn't refered to very often, so it seems to me the easiest fix would be to change the field name, and any references to the actual field itself. Thanks for the kick in the pants, Russ. If you're ever in Austin, I'll buy you a beer :) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244936 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

