Does this line:
sJavaScript = sJavaScript & "parent.frames['first'].location.href='" & rec(redirect) & "';"
get interpeted correctly or does it throw an error as well?
If that is the case, it may have to do with the rec(redirect) (which probably should be rec("redirect") if redirect is the name of a column in your recordset).
In any case, if both lines are throwing the error, make sure you have opened your recordset correctly else what you are literally trying to do is append a recordset object to a string which is a illegal.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
Discussion:
http://p2p.wrox.com/topic.asp?TOPIC_ID=56429