Problem with a subquery - TechRepublic
General discussion
January 15, 2002 at 06:18 PM
viplav76

Problem with a subquery

by viplav76 . Updated 24 years ago

Dear Sir/Madam,
I am developing an application in ASP. The database I am using is access. I would be grateful if you could help me solve a small problem. My problem is in MS-Access.
I have a table which has certain values in a particular field. These values are numbers separated by an ‘Or’. They are inserted into this table from a web page (throught ASP). I need them to be passed to an access query (procedure) as a subquery.The problem is when there is a single value (without OR) the query executes perfectly, however when more that 1 values are present separated with an ‘Or’ the query fails to return any result.
When the values are manually typed in the ‘criteria’ dialog, the query returns the results, however when they are passed in the form of a sub query (SELECT[]), & the field has more than 1 value (v1 Or v2 Or v3) it does not return any result.
Kindly help me out of this problem. Alternatively please send me addresses of sites/people who can help me solve this problem.

Awaiting your reply.
Viplav Kambli

This discussion is locked

All Comments