Dreamweaver Regular Expressions Guru Needed

[ice7899]

Having decided to implement cfqueryparam in my queries I'm trying to work out 1 Dreamweaver MX regular expression to convert the following.

WHERE CategoryID = #Val(ARGUMENTS.CategoryID)#

WHERE AdID = #Val(ARGUMENTS.AdID)#

To.........

WHERE CategoryID = <cfqueryparam value="#Val(ARGUMENTS.CategoryID#" cfsqltype="cf_sql_numeric">

WHERE AdID = <cfqueryparam value="#Val(ARGUMENTS.AdID#" cfsqltype="cf_sql_numeric">

etc

I've tried a number of formulas but they're not working

 

[grtfercho]

On the search box
#Val(\(.*\))#

on the replace box

<cfqueryparam value="#Val$1#" cfsqltype="cf_sql_numeric">

I guess you forgot the closing parenthesis on the initial post.



good luck

grtfercho çB^]\..
"Imagination is more important than Knowledge" A. Einstein
-----------------------------------------------

http://www.llajta.com