Hi there,

I have a mainpage which derives it's data from four tables. These 4 tables all have the fields "ID" and "URL". Now I want have <b>one</b> redirect page where some stuff is done like updating number fields etc. That's not the problem anyway, that part is working fine. The problem is I can't seem to get my redirect page to identify from which table the URL parameter came from. To clarify things a bit some sample code:

&lt;% Response.Redirect(rsProducts.Fields.Item("URL".Value) %&gt;

if I put the above code only in it the redirect works, but when I insert another piece of code the filtered ID's get messed up:

&lt;% Response.Redirect(rsTopics.Fields.Item("URL".Value) %&gt;

Should this be done with something like an IF / THEN / ELSE statement or something like that or isn't this possible at all? Maybe I should change the field names ID and URL, how would that work in the code?

Thanks again everybody for their help!

Rein

Something to add here: If I manually add an extra parameter like www.mysite.com/redirect.asp?ID=72&<b>Categorie=12</b>. How can I collect these parameters on the redirect.asp page and base the redirection on those two parameters. I'm thinking of this because the records become unique in that way, but yeah, I'm still a newbie to ASP <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

The redirect page should do something like this. If ID=5 and Categorie=8 then redirect the user to the URL corresponding to the ID and Categorie. I hope you understand what I mean.

Thanx