Calling Stored Procedure from an ASP Page

[anoop]

Hello,
I have a stored procedure named as

usp_CheckLogin with two parameters

as @usID, @Password

also values of these parameters are to be extracted using Request.Form from
the fields in the forms. Now How do I call this stored procedure from an ASP
Page using a Connection object in Server Tags <% %>. Also this stored
procedure returns a Numeric value as "RETURN_VALUE". please give me the
syntax. This stored Procedure is a part of Session Management module.

thank you

 

[Bob Barrows [MVP]]

Hello,
I have a stored procedure named as

usp_CheckLogin with two parameters

as @usID, @Password

also values of these parameters are to be extracted using
Request.Form from the fields in the forms. Now How do I call this
stored procedure from an ASP Page using a Connection object in Server
Tags <% %>. Also this stored procedure returns a Numeric value as
"RETURN_VALUE". please give me the syntax. This stored Procedure is a
part of Session Management module.

http://groups.google.com/group/microsoft.public.inetserver.asp.general/msg/5d3c9d4409dc1701?hl=en