|
|
|
|
|
| | |
| |
Active Server Pages ASP a directory of ASP tutorials applications scripts components and articles for the novice to professional developer. CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
SQL Query misbehaviour |
|
From: |
Sundar Narayanan |
|
Date: |
6/17/1999 7:36:11 AM |
|
IP: |
202.54.5.69 |
In my ASP code, I am using an SQL statement which goes like
this :- (the back-end database is on MS-Access 97)
Select ProblemDescription from ReqMaster where ProblemDescription like "*system*"
The query does not work. Instead, it raises the following error:
Microsoft OLE DB Provider for ODBC Drivers error 80040e14
[Microsoft][ODBC Microsoft Access 97 Driver] Expression cannot be used with the LIKE predicate.
in query expression SupportProbDescription alike `*System*`.
BUT, THE SAME QUERY WORKS IF RUN THROUGH THE QUERY
WIZARD OF MS-ACCESS.
Please advise.
Regards,
Sundar.
|
Follow Up - Re: SQL Query misbehaviour - sreeram 6/20/1999 2:46:23 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
