Thread: Strange Access problem
10-07-03, 13:13 #1Registered User
- Join Date
- Oct 2003
Unanswered: Strange Access problem
I am writing an application using access and ASP. Here is the (weird)problem: when I send this query through ASP, it doesn't return any record. However, if I try the query from Access, it works perfectly and returns several records.
This is the query:
SELECT id_organisation from FULL_VIEW WHERE organisation_name like '**' AND contact_name like '**' AND contact_position like '**' AND business like '**' AND country like '*t*' AND marketing like '**' AND interest like '**' AND AOI like '**' AND AONI like '**'
I guess the wildcards or the like clause are causing problems, becase when I try a WHERE clause using the = operator against an integer, it works fine,
Anybody help me please, it related to my work and I can not continue without this!!
10-07-03, 14:41 #2Registered User
- Join Date
- Sep 2003
Because this is not an ASP forum, I don't have specialized knowledge for your problem. You MAY want to try replacing the * with % when going through ASP.All code ADO/ADOX unless otherwise specified.