On 2/26/10, phil phil wrote: > Problem is that in my code over the years the table name can be as 'Company' > or 'company' so just changing the table names in mysql to lowercase is not > enough but yes a necessary step (can do it from the GUI: PHPadmin) > Then as you wrote changing all occurrences of the table names (1500 cfquery > tags) to lowercase. I choose lowercase but it could be also uppercase as > long as everything on the code and db is coherent. > Anyway that is the only solution that I find at this time.
How invested are you in MySQL? If your hoster offers PostgreSQL you could use that and have your case insensitive table names? Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:331181 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4