cant
use cfqueryparam for LIKE clauses cause the % will just get escaped out so it
will end up looking like
'%%word%%'
here
is a work around
DECLARE @varName varchar(100);
SET @varName = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#Arguments.Value#" maxlength="100">;
SELECT ...
WHERE column LIKE '%' + @varName + '%'
SET @varName = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#Arguments.Value#" maxlength="100">;
SELECT ...
WHERE column LIKE '%' + @varName + '%'
Steve
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
