Using Stored Procedure in ASP

[afsheen]

i am having problem in using the stored procedure defined in SQL server in
my ASP code. Can u please provide me the sample code for the purpose.

thnx

[Some Dude]

Hope This helps...

---------------------------------------------------
Dim conn
Dim rs
Dim strSQL
Dim strVal1
Dim strVal2


strSQL = "EXECUTE sp_someproc " & Param1 & ", " & Param2
Set conn = Server.CreateObject("ADODB.Connection")
With conn
.Open Application("ConnString")

Set rs = .Execute(strSQL)
strVal1 = rs("ret_val_1") & ""
strVal2 = rs("ret_val_2") & ""

.close
End With

Set rs = Nothing
Set conn = Nothing
--------------------------------------------------

Some Dude


"afsheen" <afsheen_zaidi@hotmail.com> wrote:
>
>i am having problem in using the stored procedure defined in SQL server
in
>my ASP code. Can u please provide me the sample code for the purpose.
>
>thnx
>