I am using classic ASP and an MS Access database which is in 2000 format. My problem is as follows - I have 2 tables in the db which I want to join through a query, I create a query as follows :

SELECT * FROM StoreList INNER JOIN techEnquiry ON StoreList.pkStore=techEnquiry.pkStore
WHERE StoreName LIKE '*S*';

WhenI run this through MS Access's Query Analyser (Don't know what else to call it?) It works fine and returns all records with 'S' in the StoreName. WhenI run the same request through ADO in an ASP page I get no records returned.

I am using the Microsoft Jet 4 Driver, I have MDAC 2.7 RTM (Although I have also used 2.5 with the same problem)

Has anybody else had problems like this?

any help appreciated

Marko

¿´µÃ²»Ì«Ã÷°×,ÎÒÖйúÈË,Ó¢Óï ²»ÐÐ,²»È»¿ÉÒÔhelp you µÄ.sorry

The problem is caused by the ADO layer between your page and Access. Although Access usually requires the * as a wild card, for ADO you should pass the percentage symbol. This: should do the trick.

You can also leave the semi-colon at the end, if you want.

Cheers,

Imar




---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Thank you so Much, I was just about to give up as well!
This brings me to the point of what I was doing originally and that was using a stored query in the MS Access DB. The stored query was just like the query I posted and that worked in Access Query Analyser but not through the code, I have now got the query working passing in direct as a query with %'s instead of *'s. If I now alter the Stored Query and use %'s it works through ADO but not through the MS Access Query Analyser - I can definitely live with that one.

Thank you again.

I have a similar question and can't figure out what I'm doing wrong. I'm running SQL Server 2000 and in Query Analyser, I'm trying to write an "update" string and it won't updat my records. Here is the line : update INMAST set FPRODCL ='S1' where fpartno = '*r'

I have tried '%r', '*r', and '&r'. All say 0 rows updated. Any thoughts?

If you want to use wildcards you must use LIKE not =
...WHERE fpartno LIKE '%r'
will update all records where fpartno ends in 'r'