02-03-02, 17:34 #1Registered User
- Join Date
- Feb 2002
Unanswered: Query works in native Access but not in VBScript
I have a simple query which I am using in VBScript within an ASP 3 environment running on Win2K pro with IIS 5. The SQL string is
SELECT tblContacts.* FROM tblContacts WHERE ((tblContacts.Consultant='martin') AND (Groups LIKE '*Personal*')) ORDER BY LastName ASC;
The code executes without error in both the web application and within ACCESS itself. However, the web version returns an empty record set, whilst the ACCESS code returns the expected records.
2 requests: somebody please explain why this is happening, and also give me a hint/solution to this problem - it's driving me nuts!!