Dear gurus,
I looked through MSDN, but couldn't find the answer. So here is the problem. I use Access database and I have there the following query with a parameter:
Question: How can I pass this parameter (currCatID) from my ASP page?
Let's say, myConn is the connection object and myRS is the recordset, so what would be the SQL string for myRS?
Thanks a lot in advance!!!
---
---
I looked through MSDN, but couldn't find the answer. So here is the problem. I use Access database and I have there the following query with a parameter:
Code:
PARAMETERS currCatID IEEEDouble;
SELECT email
FROM experts
WHERE ID in (SELECT expertID
FROM catExp
WHERE CategoryID=currCatID);
Question: How can I pass this parameter (currCatID) from my ASP page?
Let's say, myConn is the connection object and myRS is the recordset, so what would be the SQL string for myRS?
Thanks a lot in advance!!!
---
---