query with parameter in ASP 1

[Rydel]

Dear gurus,

I have a question on how to call query with a parameter from ASP pages. To illustrate my problem with an example let's say, I have myDB.mdb and in it I have the following query named myQuery:

PARAMETERS currAge;
SELECT * FROM experts WHERE Age>currAge;

I also have something like this in an ASP file:

set cnn = Server.CreateObject("ADODB.Connection")
cnn.Open "driver={Microsoft Access Driver *.mdb)};;DBQ=d:/myDB.mdb;"
strSQL = ???????? ' here I want to call the above query and supply the parameter currAge!
set Results = cnn.Execute(strSQL)

Question: what goes into strSQL=?????? instead of question marks to call the Access query and supply the parameter for it.

Thanks a lot in advance! ---

http://www.geocities.com/rydel23/

---

 

[Cagliostro]

nothing. It is just a string. You get a recordset as return. John Fill

ivfmd@mail.md

 

[tlbroadbent]

Check out this Knowledgebase article:

http://support.microsoft.com/support/kb/articles/q200/1/90.asp

Terry

http://members.home.net/tlbroadbent/index.htm

 

[Rydel]

Thanks. That KB article was exactly what I was looking for.
---

http://www.geocities.com/rydel23/

---