Retrieve URL from DB

[coryd218]

Does anyone know how to pull a URL from a DB?

Here's my example:

I have a database with training records in it. Inside the DB people fall under
group 1, 2, 3, or 4. Each of these groups has a Master trainer. I want to
create an account for each Master Trainer. Say Master Trainer1, Master Trainer
2, etc. Also in this DB i have a column called URL. For all members it is blank
and they will just view there records. For Master Trainers I want to create an
if statement that says if they login, go to the URL in the DB.

This will be on my validate.cfm

<cfif '#form.username#' = "Master Trainer1">
statement to pull URL from DB

<else>
go to the users records
</cfif>

Please Help!

[adonis1976]

<cfif '#form.username#' = "Master Trainer1">
<cfquery name="qGetUrl" datasource="#datasource#">
select url from db_name
where user_name = '#form.username#'
</cfquery>
<cflocation url="#qGetUrl.url#">
<else>
go to the users records
</cfif>

[coryd218]

AWESOME! Thanks.