MSDE and count operator
I was using the following select statement on access database it was working fine. Now i am using MSDE, now i am geting following error
str= "select count(*) from messages where sender_id='" & id & "'"
Set rsEvents1 = server.CreateObject("ADODB.Recordset")
rsEvents1.Open str, Conn
Microsoft OLE DB Provider for SQL Server (0x80040E14)
The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
/ambdex/login_check.asp, line 119