Need help with dreamweaver regular expressions as part of the find and replace function.
I'm trying to work out 1 Dreamweaver MX regular expression to convert the following.
WHERE CategoryID = #Val(ARGUMENTS.CategoryID)#
or
WHERE AdID = #Val(ARGUMENTS.AdID)#
To.........
WHERE CategoryID = <cfqueryparam value="#Val(ARGUMENTS.CategoryID#" cfsqltype="cf_sql_numeric">
or
WHERE AdID = <cfqueryparam value="#Val(ARGUMENTS.AdID#" cfsqltype="cf_sql_numeric">
etc
I've tried a number of formulas but they're not working
I'm trying to work out 1 Dreamweaver MX regular expression to convert the following.
WHERE CategoryID = #Val(ARGUMENTS.CategoryID)#
or
WHERE AdID = #Val(ARGUMENTS.AdID)#
To.........
WHERE CategoryID = <cfqueryparam value="#Val(ARGUMENTS.CategoryID#" cfsqltype="cf_sql_numeric">
or
WHERE AdID = <cfqueryparam value="#Val(ARGUMENTS.AdID#" cfsqltype="cf_sql_numeric">
etc
I've tried a number of formulas but they're not working