Redirect to URL in database

[coryd218]

Okay, i have a slight problem. I have developed a login page for section
managers of my workplace. Once they login it should take them to a page that
displays their personnel and there training status. I have their login,
password and URL to their page in a table that is in the database.

So heres how i have it now. They login and it sends there id and password to
validate.cfm. This page checks the id and password and verifies it matches.
There are several IF statements in this validate page to determine who the
person is, and what URL to go to. On the screen they just see a page that says
LOADING and it has our logo on it. I was using a javascript redirect so the
page would redirect to one particular page. I used this for individuals and it
worked fine b/c the template page worked for everyone. Each page for the
managers is different however (different types of training) and it needs to be
sent to their particular page listed in the database or in an IF statement.

Is there anyway to have an auto redirect to their URL that is in a database or
one that i list in an IF statement? Please Help!

[simontux]

What about using <cflocation addtoken="no" url="......">

This should do the job if I am understanding your question correctly.