MSDE and count operator

		Wrox Programmer Forums > Wrox Announcements and Feedback > All Other Wrox Books
MSDE and count operator

All Other Wrox Books Do you have a question about a Wrox book that isn't listed anywhere on p2p.wrox.com or where the forum is locked? Here's a forum to post questions about any other Wrox book so that other readers or one of the authors can help you with your questions. IF YOU ARE LOOKING FOR CODE DO NOT ASK "Where can I find the code for this book?" That question is answered here.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the All Other Wrox Books section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

#1 (permalink)

February 16th, 2004, 02:23 AM

isheikh

Authorized User

Join Date: Feb 2004

Posts: 57

Thanks: 0

Thanked 0 Times in 0 Posts

MSDE and count operator

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to use like operator	thillaiarasu	SQL Server 2000	4	April 23rd, 2010 09:47 AM
=== operator in c#	surendraparashar	C# 2005	8	November 8th, 2007 05:14 AM
Invalid operator for data type. Operator equals di	Pusstiu	SQL Server 2000	2	August 10th, 2007 04:51 AM
is there any in built function to count page count	g.tamilselvan	MySQL	1	February 15th, 2006 07:43 AM
Count, sum, count a value, return records	CongoGrey	Access	1	April 18th, 2005 02:25 PM