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
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")
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.
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")
I resolved this. Here is the query that worked:
sql="exec fp_qr_code '" & request.querystring("id") & "'"
set rs = Conn.Execute(sql)
if rs.eof then response.write("No Records")
while not rs.eof
Europe, Middle East and Africa