...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:
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

i see, well it all worked until the rec("redirect") went in thus suggesting the recordset has not been connected correctly.
indeed the "redirect" is a column name in the database, the dynamic redirect worked great until i wanted to load to the parent frame and the Response.Redirect(rec("redirect")) was replaced by the Response.Write(sJavaScript).

if i remove the dynamic redirect and simply put in "page.html" then it redirects accordingly into the parent frame.

I would say try doing a Response.write(rec("redirect")) if it displays the value of that column then you can try something like this:

sJavaScript = sJavaScript & "parent.frames['first'].location.href='" & CStr(rec(redirect)) & "';"

================================================== =========
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

i tried both your changes, and the same error appears unfortunately

...I only gave you one change. What i am saying is that if you can do this: Response.write(rec("redirect")) and the value is correctly wrote out to the page, then you would need to adjust your javascript string.

If simply doing this:
Response.write(rec("redirect"))

produces an error, then your recordset is not opened correctly and it is a database issue.

================================================== =========
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

ok, i will have a look

many thanks

you were right - there was an issue with the database that is now rectified and it went through first time! thanks for all that - learnt some more now!

glad you got it worked out.

================================================== =========
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

two things....

1. is it possible when the user logs in to delete cookies as im having a small issue with that

and...

2. if you can, is it easy or hard to set up?

thanks

Yes, and its easy to set up. A google search should net you quite a few results on how to delete cookies.

================================================== =========
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