http://cfzen.instantspot.com Zen moments in a ColdFusion life en-us This work is Copyright © 2009 by cfZen RSSVille ColdFusion FeedMaker, version 1.0 Sat, 21 Nov 2009 13:30:57 GMT http://cfzen.instantspot.com/blog/2008/07/16/RegEx-to-find-SQL-in-code-without-CFQueryParam <p>I know it's far from perfect (that's partly why I'm posting - so you can show me the light), but here's a RegEx I'm using in Eclipse to find all the places in our code where we didn't use CFQueryParam around variables (shame, shame). Please let me know if you see ways to improve it.</p> <p><div class="code" ><pre>\s+(where|set)\s+[a-z_\.]+\s+(like|\=)\s+'?%?#[a-z&quot;_'\.\(\)\+\/]+#%?'?</pre></div></p> <p>And can someone help me figure out how&nbsp; to make this Regex include CF variables passed in to INSERT statements?</p> <p>TIA</p> Wed, 16 Jul 2008 20:35:00 GMT http://cfzen.instantspot.com/blog/2008/07/16/RegEx-to-find-SQL-in-code-without-CFQueryParam ColdFusion,CFEclipse,Regex http://cfzen.instantspot.com/blog/2007/03/26/Why-blog-about-ColdFusion <p> To give back. </p> Mon, 26 Mar 2007 20:29:36 GMT http://cfzen.instantspot.com/blog/2007/03/26/Why-blog-about-ColdFusion ColdFusion