yes. REReplace. The pattern your trying to match is the first line. It says that we're looking to capture something that starts with a cfquery tag, has content, and then ends with a closing cfquery tag. The replace has a \L before the content returned from the pattern (the query tag). \L means that everything that comes after it will be lower cased. End result is a whole cfquery tag along with body converted to lower case.
-- Michael Dinowitz On Fri, Feb 26, 2010 at 7:07 AM, phil phil <arantxa...@gmail.com> wrote: > > It cost me to make the below code to work. Should I use a Rereplace > expression? > (<cfquery[^>]+>.+?</cfquery>) > \L\1 > > Thanks in advance for your feedbacks > > >>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 >> >> >> >> >> >>> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:331167 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4