Response.Direct depending on database value

[beish1]

I want to have simple aspx page which reads a database record, selecting it according to parameter received (ie request.querystring).

I then want it to check a field on the database record and redirect to one of four pages depending on whether the value of the field is 1, 2, or 4

eg if 1 response.redirect("page1.aspx")
if 2 response.redirect("page2.aspx") etc

I need to do this without any intervention from the user ie not using any button on the page.

I've tried various methods using code behind page but not getting anywhere.

Can anyone help?

[DrBunchman]

Use a Case statement. e.g.

Select Case RecordSetObject("fieldname")
    Case 1
        response.redirect("page1.aspx")
    Case 2
        response.redirect("page2.aspx")
    Case 3
        response.redirect("page3.aspx")
End Select

By the way, you've posted your question in the ASP Forum which is for Classic ASP only - I've moved it for you but in future please post all ASP.NET questions in the .NET Forum.

Hope this helps,

Dr B

[beish1]

Many thanks Dr B - the simplest methods are always the best!