calling Access query with parameter from ASP

[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/

---

 

[Deadline]

Have you found the answer for your problem ? Thanks!

RR

 

[Guest_imported]

this will work . I use it.


<%
Set cn = Server.CreateObject (&quot;ADODB.connection&quot
Set cmd = server.CreateObject (&quot;ADODB.command&quot
Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot
cn.Open &quot;Driver={Microsoft Access Driver (*.mdb)};&quot; & _
&quot;DBQ=C:\Inetpub\

http://wwwroot\Ecom_project\EcomDB.mdb&quot;

With cmd
.CommandText = &quot;Query1&quot;
Set .ActiveConnection = cn
End With

'rs.CursorLocation = adUseClient

set rs = cmd.Execute'

while not rs.eof
Response.write (rs(0))
rs.MoveNext
wend
rs.Close
cn.Close
%>
</table>