cfqueryparam with the LIKE syntax

[GUJUm0deL]

Would this work?

DELETE FROM CategoryXYZA12_1
WHERE CPath12a LIKE <cfqueryparam cfsqltype="cf_sql_integer" value="%/#url.id#/%">

I've never used the cfqueryparam with the LIKE syntax and the % sign.

Thanks.

_____________________________
Just Imagine.

http://www.imajinarts.com

 

[Sarky78]

Close:

CPath12a LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%#url.searchtext#%">

You don't need the /'s

Hope this helps!

Tony

 

[GUJUm0deL]

Thanks!

The /'s are used because the #url.id# is a folder name.

_____________________________
Just Imagine.

http://www.imajinarts.com