Stored procedure and ASP

Results 1 to 2 of 2

Thread: Stored procedure and ASP

  1. #1
    Veronica Guest

    Default Stored procedure and ASP

    How can I call a stored procedure in ASp code?

  2. #2
    Join Date
    Dec 1969

    Default RE: Stored procedure and ASP

    I give one small ex.<BR><BR>&#060;%<BR>Dim comm,RsPass <BR>set comm=Server.createobject("ADODB.Command")<BR>set RsPass=Server.createobject("ADODB.Recordset")<BR>< BR>comm.ActiveConnection =con<BR>comm.CommandText = "pro_employer_password" &#039;Procedure name.<BR>comm.CommandType = adCmdStoredProc<BR><BR>comm.Parameters.Append comm.CreateParameter("login", adVarChar, adParamInput,12)<BR>comm.Parameters(0)=request("lo gin")<BR>RsPass.Open comm<BR>%&#062;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts