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
