Skip navigation
bake1234
Currently Being Moderated

Need Help Running Stored Procedure in ASP

Jun 11, 2012 12:23 PM

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.

 
Replies
  • Currently Being Moderated
    Jun 11, 2012 1:20 PM   in reply to bake1234

    You have a variable inside your sql string which will never be evaluated. I think you'd be much better off using the command object, but if you still want to use the Open method, try this:

     

      sql="exec dbo.fp_qr_code @sequence =" & request.querystring("id")

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 11, 2012 1:49 PM   in reply to bregent

    I made that change, but it is still creating a 500 Server Error.  I do appreciate your effort, however.

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 11, 2012 8:53 PM   in reply to bake01

    I always used the command object for stored procedures. That's what I would suggest at this point.

     
    |
    Mark as:
  • Currently Being Moderated
    Jun 18, 2012 10:12 AM   in reply to bake1234

    Of course. The sproc parameter needed to be quoted. Good catch.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points