I was wondering if there is a way to keep an ADO connection open when a page refreshes or going to a next page.
That's basically not done with Web pages.
Generally speaking you can pass variables from page to page by:
1) Posting form fields from one page to the next (or to the same page) and on the page to retrieve the value strLName = Request.Form("LName")
2) Using a querystring such as Response.Redirect "login.asp?lname=smith&fname=tom" and on the page to retrieve the values strLName = Request.QueryString("lname") and strFName = Request.QueryString("fname")
3) Using session variables such as Session("LName") = "Smith" and on the page to retrieve the value strLName = Session("LName")
Thanks guy's. I didn't think that was possible, but was worth trying.
The problem I have is on the first page a customer filles out a form, clicks submit. The submition to the DB happens on the next page. Then there is more stuff to fill out and click submit again, the info gets passed in and goes on to the 3rd paged. Here is where the problem is. If the customer presses the back button to the 2nd page, the call to submit the info is going to happend again.
How to avoid this and not have a bunch of variables going from page to page?