CFQuery And S.Q.L. 2000 Server

[velvetpuppet]

I'm usin' Coldfusion & S.Q.L. 2000 Server database. I'm tryin' to match the exact word that a user enters with a field called Contents.

I tried the followin' CFQuery:
<CFQuery name=&quot;Q_Users&quot; datasource=&quot;DSN_IXS&quot;>
Select * From Users
Where User_ID In (#Category#)
And Contents = '#Keyword#'
</CFQuery>

But that CFQuery gave me an err msg sayin':
The text, ntext, and image data types cannot be compared or sorted, except when using NULL or LIKE operator.

I tried to replace the LIKE operator with the (=) operator as the followin':
<CFQuery name=&quot;Q_Users&quot; datasource=&quot;DSN_IXS&quot;>
Select * From Users
Where User_ID In (#Category#)
And Contents LIKE '#Keyword#'
</CFQuery>

This time I got no err msg, but I got no result even if the word is contained in the Contents field.

Do you suggest any solution to the problem?

With regards

 

[Bramvg]

Could it be possible you need to use &quot;&quot; instead of '' ?

So: And Contents LIKE &quot;#Keyword#&quot; ?

Regards
Bram

 

[ram123]

you need add % at both ends %#keyword#%
like this

<CFQuery name=&quot;Q_Users&quot; datasource=&quot;DSN_IXS&quot;>
Select * From Users
Where User_ID In (#Category#)
And Contents LIKE '%#Keyword#%'
</CFQuery>

 

[ram123]

you need to add % at both ends %#keyword#%
like this

<CFQuery name=&quot;Q_Users&quot; datasource=&quot;DSN_IXS&quot;>
Select * From Users
Where User_ID In (#Category#)
And Contents LIKE '%#Keyword#%'
</CFQuery>