Redirect based on a database field

Thanks FtB. That is basically what I want to do, but how do I do that?

One way:

<meta http-equiv="refresh" content="0;url=http://www.YourURL.com/YourPage.asp">

But it would just be easier and more reliable to put a redirect on the page:

Response.Redirect("YourPage.asp")


FtB

I've gotten to the point where I can send the values. Here is the query string collection from one of the records:

Request Sniffer

--------------------------------------------------------------------------------
From QueryString collection - GET
Total # of values = 3
Entire QueryString Collection as String:
DestID=8&Redirect=True&URL='http%3A%2F%2Fwww%2Emountainnature%2Ecom%2FDest%2FCanada%2FAlberta%2FBanff'


DestID 8
Redirect True
URL 'http://www.mountainnature.com/Dest/Canada/Alberta/Banff'


Now I just need a way to say if Redirect = "True" then redirect to URL, otherwise go to ParkFinderResults.asp with the appropriate DestID.

Okay, I think that I get what you mean.

If Request.QueryString("Redirect") = "True" then
   response.redirect(Request.QueryString("URL"))
else
   response.redirect("ParkFinderResults.asp?DestID=" &  Request.QueryString("DestID") )
end if

FtB

It should work but it doesn't. I think it is the slash "/" and the periods that mess things up. I just get a HTTP/1.1 404 Object Not Found error.

Here is the code:

<%
If Request.QueryString("Redirect") = "True" then
   response.redirect(Request.QueryString("URL"))
else
   response.redirect("ParkFinderResults.asp?DestID=" &  Request.QueryString("DestID") )
end if
%>

Now if I select a site that has no value for the Redirect field, the page IS properly redirected to ParkFinderResults.asp as stated under the else portion.

If I change the If statement to
If Request.QueryString("Redirect") = "True" then
   response.write "should be redirected"

I do see the "should be redirected" printed so I know it has read the Redirect = "True" from the query string.

The problem is in the interpreting of the url. I had this problem with another page and it was solved using post rather than get, but in this case I don't have that option because I need to send numerous parameters at the same time.

Take out the apostrophies around the redirect URL :

DestID=8&Redirect=True&URL=http%3A%2F%2Fwww%2Emountainnature%2Ecom%2FDest%2FCanada%2FAlberta%2FBanff

How?

If you still have problems after removing the apostrophes (good catch, alorentz) then do the following:

response.redirect(unescape(Request.QueryString("URL")))

FtB