>If you change the setting for mysql to lower_case_table_names=1 >instead of the default 0, you won't have to worry about the upper >case names in your code. MySQL will lowercase all of the names when >it runs the query. Then you don't have to change your code.
Oh, great. I had heard about that but thought it just pretended the table names themselves were lowercase, not the cfquery code. I see now it is actually the opposite and I'll have to change the database names: "Note that if you plan to set the lower_case_table_names system variable to 1 on Unix, you must first convert your old database and table names to lowercase before restarting mysqld with the new variable setting." Thanks. Just have to hunt down the img/file names and such now. If anyone still has any trusty regexs for those... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276734 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4