Stored Procedure

Results 1 to 2 of 2

Thread: Stored Procedure

  1. #1
    Join Date
    Dec 1969

    Default Stored Procedure

    Hi. I have a stored procedure that accepts one parameter. What is the syntax that I can use from my asp page to pass this parameter and run the stored procedure?<BR><BR>For Example I have...<BR><BR>Dim sSQL<BR> sSQl = "sp_passed"<BR> Set rs1 = conn.Execute(sSql)<BR> //? How do I pass the parameter?<BR><BR>THanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: Stored Procedure

    Embed it in the SQL String ...<BR><BR>Dim sSQL<BR>sSQl = "sp_passed &#039" & VariableName & "&#039" <BR>Set rs1 = conn.Execute(sSql)<BR><BR>Notice the Single Quotes.... Needed only if parameter is a character or date field ...<BR><BR>Also you may want to investigate ADO&#039s Command Object (do a search on 4Guys for it) <BR><BR><BR>

Posting Permissions

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