Re: regex or other easy way to change code to lowercase for linux
>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
Re: regex or other easy way to change code to lowercase for linux
stylo, 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. http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html HTH, Jon On May 1, 2007, at 8:23 AM, stylo stylo wrote: > Can anyone suggest a regex or another easy way to change all the > cfquery table name code and other required bits (file names, etc.) > to lowercase for linux/mysql? I'm using homesite. > > For example, I can't seem to come up with a regex for cfquery that > isn't greedy but allows tags inbetween the start and finish. > > Searching and checking all the table names would be awful, so I > just want to set everything to lowercase and go from there. > > Btw, if you have a WHERE table.field clause, does mysql require > that table name to be case sensitive just like in the FROM clause? > > Thanks. ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276620 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
regex or other easy way to change code to lowercase for linux
Can anyone suggest a regex or another easy way to change all the cfquery table name code and other required bits (file names, etc.) to lowercase for linux/mysql? I'm using homesite. For example, I can't seem to come up with a regex for cfquery that isn't greedy but allows tags inbetween the start and finish. Searching and checking all the table names would be awful, so I just want to set everything to lowercase and go from there. Btw, if you have a WHERE table.field clause, does mysql require that table name to be case sensitive just like in the FROM clause? Thanks. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276606 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
