Here is our strategy. We will create four web pages and a .DLL for our purposes:
login.asp. This page will be the first one that a user sees when they visit our site. It will look for a cookie and if one is present it will be sent to the next page,
visitor.asp
.
visitor.asp. This page checks for the value of the cookie. If there is a valid value, then this page will instantiate a DLL that will open an ADO connection. A recordset of data about that user will be updated and then displayed. If there is no valid value for the cookie, we know this is a new user. Then control will be redirected to the page
newUser.asp
.
newUser.asp. This page will prompt the new user for their first and last name. The user submits this information to the
updateNewUser.asp
page.
updateNewUser.asp This page retrieves the First and Last name from the user, instantiates a DLL that opens an ADO connection and creates a new user record. The DLL returns a unique number that is then written to the user's PC inside a cookie. The form then notifies the user that their data has been successfully updated.
visitors.dll This will open the connection and handle all of the database operations for us.