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.
>
> Is this the way it is?
>
> I have to go back into the code and rename each table to
> lowercase so it will run properly.
>
> I take it there is no magic setting or something to change this
> in the configuration or something?
>
What OS is MySQL installed on? Has to be some kind of LINUX/UNIX
variant - or maybe Mac OS X depending on your settings. I never knew
this before either, but with a particular query the case of the table
name cannot change.
The following query is not allowed:
select * from my_table where my_Table.ID = 101;
More documentation can be found in dev.mysql.com.
--
2004 - The year $184M couldn't buy a pennant.
Ron Artest: Extremely flawed, very accidental, semi-martyr
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase Captivate from House of Fusion, a Macromedia Authorized Affiliate and
support the CF community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=52
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:143787
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=89.70.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
