Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
isheikh
Starting Member
25 Posts |
 Posted - 2004-02-16 : 01:23:46
|
hi,
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
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-02-16 : 04:37:28
|
Have a look at messages
What datatype is sender_id?
it should probably be varchar(n) but it looks like it is text
==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
msde and count operator