Do you need all of the query lowercased or is there part that you want to keep uppercased? If you don't care then this regex will do the job:
(<cfquery[^>]+>.+?</cfquery>) \L\1 The first line grabs all cfquery tags and their content and the second like converts it to lower case. I'd test the regex against all of your templates first to see if there are any cases that you want to avoid. You can use just about any regex tool to do the job, including writing a fast tool in CF to do the job. -- Michael Dinowitz On Fri, Feb 26, 2010 at 4:57 AM, phil phil <arantxa...@gmail.com> wrote: > > 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:331159 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4