It seems that the table name is case sensitive but not the columns. For e.g if I change the name of the table to 'company' from 'Company' then it cannot find the table because in MYSQL it is referred as 'Company'. BTW, we are on Linux which I understand is case sensitive.
>If I recall right, you have to switch case sensitivity on, are you saying >that is what your host has done? > > > > >Hello, > >I do need to migrate from Access to MySQL on a Windows and shared server >environment. >All existing queries (approx 2000) are failing because they are not >lowercased. > >Does anyone know of a script that would look into every files for the >CFquery tag and lowercase its content between? > >This is the only solution that comes to me but maybe there is a easier way? > >Thanks in advance for any feedbacks. > >Phil ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331166 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4