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 errorstr= "select count(*) from messages where sender_id='" & id & "'"Set rsEvents1 = server.CreateObject("ADODB.Recordset")rsEvents1.Open str, ConnMicrosoft 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 messagesWhat 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