5 Replies Latest reply: Jun 18, 2012 10:12 AM by bregent RSS

    Need Help Running Stored Procedure in ASP

    bake1234 Community Member

      I have a web page in which I would like to use a query string like http://ereply.us/q/l.asp?id=383966476


      This takes the user to a page with the following code:


      <!-- #include file="database_connection.asp" -->
      if not isempty(request.querystring("id")) then
        sql="exec dbo.fp_qr_code @sequence =(request.querystring("id"))"
      if rs.state=1 then rs.close
         rs.open sql,conn,3,2
         if rs.recordcount<>0 then
           session("name") = rs("name")
        session("jobid") = rs("jobid")
        session("seq") = rs("seq")
      if rs("id")<>"" then response.Redirect("index.asp")
      end if
      end if


      This queries a SQL database to return the "Name" value. In turn, as the code implies the user should be directed to "Index.asp" which contains:


      Welcome  <% response.write(session("name"))%>


      And the page should render the page with "Welcome Name".  Instead I get a 500 Server Error.  The Stored Procedure works as a stand-alone query in SQL Management Studio.


      Any ideas would be greatly appreciated.