How  do you pass parameters with stored procedures?

This is my code. I have problem in the **marked line.
my stored procedure name is pGetReport. I have to send clid,mon,ye
parameters.

How can you do that?

clid =request.querystring("clid")
mon =request.querystring("mon")
ye =request.querystring("ye")
' Create an ADO database connection
set cn1 = server.createobject("adodb.connection")
set rs = server.createobject("adodb.recordset")
' Open the connection using our ODBC file DSN
cn1.open "89gjtru89","yyyy","fj457389jf"
** sSql = "pGetReport " & clid&mon&ye
Set rs = cn1.Execute(sSql) 'execute sql call

If you want to do it that way you'd better do it like this:

<%
strSQL =  "pGetReport @Param1=" & clid& & ", @Param2=" & mon& ", @Param3=" &
ye
Set objRS = objConn.Execute(strSQL)
%>

Personally I recommend using a Command object, and creating and appending
appropriate parameter objects.

Cheers
Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Elildo Mancebo Reis" <elildo@m...>
Subject: [access_asp] How do you pass parameters with stored procedures?


:
: How  do you pass parameters with stored procedures?
:
: This is my code. I have problem in the **marked line.
: my stored procedure name is pGetReport. I have to send clid,mon,ye
: parameters.
:
: How can you do that?
:
: clid =request.querystring("clid")
: mon =request.querystring("mon")
: ye =request.querystring("ye")
: ' Create an ADO database connection
: set cn1 = server.createobject("adodb.connection")
: set rs = server.createobject("adodb.recordset")
: ' Open the connection using our ODBC file DSN
: cn1.open "89gjtru89","yyyy","fj457389jf"
: ** sSql = "pGetReport " & clid&mon&ye
: Set rs = cn1.Execute(sSql) 'execute sql call
:
:
: