Hmm, The regular expression below does not work for me.
Using Agent ransack there is a Test option. It doesn't work with the test phrase: INSERT INTO MY_TABLE_NAME WITH (NOLOCK) Oh well. Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service p: +61 02 49213589 m: 0413800242 >>> "Charlie Arehart" <[EMAIL PROTECTED]> 14/02/2007 7:20 am >>> Here's an interesting free (Windows only) alternative to better file searching. I wrote about it when I was at New Atlanta: http://bluedragon.blog-city.com/tool_tip_for_better_windows_file_searching_u se_agent_ransack.htm It even offers a means to build RegEx's by example (you fill in the words and phrases and it builds the regex that it will understand). In fact, it offered the following for yours and it found one when I tested it: (insert into).+(with \[nolock\]) /Charlie http://www.carehart.org/blog/ -----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Haikal Saadh Sent: Monday, February 12, 2007 11:33 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Dreamweaver regular expressions It's enough to drive one insane.. There's java regexes, CF regexes, dw regexes, vi ,vim , grep, sed and awk, gnu AND bsd variants and perl... plus the escaping... Enough to drive you insane... Chris Velevitch wrote: > Use eclipse/cfeclipse. It uses standard RE. > > On 2/13/07, Blair McKenzie <[EMAIL PROTECTED]> wrote: > >> Sorry, it looks like Dreamweaver doesn't use the standard RE /.../ >> bracketing. Try the expressions without the slashes on the ends. >> >> >> On 2/13/07, Scott Thornton >> <[EMAIL PROTECTED]> wrote: >> >>> Hi, >>> >>> Both searches return no results. >>> >>> Do underscores in table names effect that pattern? eg MY_TABLE_NAME ? >>> >>> >>> >>> >>>>>> "Blair McKenzie" <[EMAIL PROTECTED] > 13/02/2007 2:10 pm >>> >>>>>> >>> Assuming your table names do not include spaces: >>> /INSERT INTO [^ ]* WITH (NOLOCK)/ >>> >>> If you have indenting etc in the sql then: >>> /INSERT\s*INTO\s*[^\s]*\s*WITH\s*(NOLOCK)/ >>> >>> Blair >>> >>> On 2/13/07, Scott Thornton >>> >> <[EMAIL PROTECTED]> wrote: >> >>>> Hi, >>>> >>>> I need to look through my code for the INSERT INTO * WITH (NOLOCK) >>>> where the * can be any table name. >>>> >>>> Can anyone advise what the correct syntax may be? >>>> >>>> ta, >>>> >>>> Scott Thornton, Programmer >>>> Application Development >>>> Information Services and Telecommunications Hunter-New England Area >>>> Health Service >>>> p: +61 02 49213589 >>>> m: 0413800242 >>>> >>>> >>>> >>>> >>> >>> >>> >>> >> > >> >> > > > -- Haikal Saadh Applications Programmer ICT Resources, TALSS QUT Kelvin Grove --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---