use ado command object: below is a example,ASP call sql procedure and get RETURN_VALUE VC use the same way as ASP call SQL SP. .... set au_adocmd=server.CreateObject("adodb.command") au_adocmd.CommandText="usp_addemployee" au_adocmd.ActiveConnection=constr au_adocmd.CommandType=adCmdStoredProc '4set p=au_adocmd.Parameters p.Append au_adocmd.CreateParameter("RETURN_VALUE",3,4) p.Append au_adocmd.CreateParameter("@lastname",200,1,12) ... au_adocmd("@reportsto")=report_to au_adocmd.Executereturnvalue=au_adocmd.Parameters("RETURN_VALUE").Valueif returnvalue=3 then ...
below is a example,ASP call sql procedure and get RETURN_VALUE
VC use the same way as ASP call SQL SP.
....
set au_adocmd=server.CreateObject("adodb.command")
au_adocmd.CommandText="usp_addemployee"
au_adocmd.ActiveConnection=constr
au_adocmd.CommandType=adCmdStoredProc '4set p=au_adocmd.Parameters
p.Append au_adocmd.CreateParameter("RETURN_VALUE",3,4)
p.Append au_adocmd.CreateParameter("@lastname",200,1,12)
...
au_adocmd("@reportsto")=report_to
au_adocmd.Executereturnvalue=au_adocmd.Parameters("RETURN_VALUE").Valueif returnvalue=3 then
...