Actually it was my stupidity. It was a Foreign Key pair that did not exist any longer. Sorry about that
-----Original Message----- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: Friday, January 21, 2005 11:55 AM To: CF-Community Subject: Re: MySQL Table Names? 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:143812 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
