Store Procedure Result to ASP

Results 1 to 2 of 2

Thread: Store Procedure Result to ASP

  1. #1
    Join Date
    Dec 1969
    Posts
    18

    Default Store Procedure Result to ASP

    Hi Guys,<BR>Here is the deal, I have this procedure:<BR>CREATE PROCEDURE MYID AS<BR>PRINT "A123"<BR><BR>The question is:<BR>How do I put this value(123) in an ASP variable? <BR>I tried like this but, didn&#039t work:<BR><BR> myConn.Open "aaa","aaa","aaa"<BR> sql="MYID"<BR> Set Rs=myConn.Execute(sql) <BR> ID=Rs.fields(0).value<BR><BR>Where the last line is what I want...ID="123" <BR><BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: Store Procedure Result to ASP

    What error(s) do you get? Try changing your procedure to:<BR><BR>CREATE PROCEDURE MYID AS<BR>SELECT &#039A123&#039<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
  •