...It is my understanding that rec is a recordset object and "redirect" is a column that exists in the recordset. If this is so then, as long as you have opened your database connection and recordset, you should be able to pull the value from your recordset and supply a dynamic URL to that string. (Provided EOF on the recordset is not true)
What you need to understand is, all of your code is evaluated BEFORE it is ever sent to the browser. Which means that any variables that are appened to a string, for example, their literal values will be evaluated and added to the string and that is what will be displayed to the user.
As i said, if rec is indeed a recordset and "redirect" is a column in that recordset, whatever value exists in that column will be the location that the parent points to.
Read this if you want to know how to get a correct reply for your question:
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
Technical Editor for: Professional Search Engine Optimization with ASP.NET