Web+Center Support
22 Oct

Knowledge Base Detail

Case Summary: Error in Customer Search Page (DoCSearch.asp) For SQL*Server Users
ID: 401
Date Created: 08/17/2001
Last Modified: 09/04/2001
Problem Type: Problem Report
Item: Web+Center 3.0
Resolution:
If you get the error:
Microsoft][ODBC SQL Server Driver][SQL Server]The text, ntext, and image data types cannot be used in the WHERE, HAVING, or ON clause, except with
the LIKE or IS NULL predicates.

/customer30/DoCSearch.asp, line 292

Then you will need to comment out line 292 and use uncomment the SQL definition line next to it that for SQL*Server users.

Return to FAQ List


Home | Search

Web+Center
Free and affordable Web-based Help Desk
Version: Ver. 9.0 - 02.07.17
(C) 2015 Internet Software Sciences
www.inet-sciences.com