Adkins, Randy wrote: > Does anyone else have the problem that with NaviCat, > when I create or import tables, it makes the table names > all lowercase. > > It seems when running a query from CF, that if the table > names are not identical (meaning case) that it throws > an error.
I don't use navicat, but it is the way MySQL works. Table names are case sensitive on case sensitive OS's. The easy way out is to make sure all your table names are lowercase, your second best shot is to alias all table names. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:143810 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
