Stefan
Mon May 05 03:10:22 CDT 2008
The script on
http://support.microsoft.com/kb/825498 is just a log on script for users already in the database
Somewhere you added a Register script for users not in the database
That is the one you need to Edit to sent to the log on script 1st & only if it fails, then send them to the register script
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
"Rhyno" <Rhyno@discussions.microsoft.com> wrote in message news:2C3289D0-CDD1-4ACD-A416-2F5DDE08305A@microsoft.com...
| Hi Stephan
|
| Thanks for getting back to me.
|
| Unfortunately I'm no code wizard, I'm not sure exactly what you mean by use
| the same process for logon... also don't know where the code you've provided
| should go or how I should edit it...
|
| Sorry, I'm trying but I think it's a case of fish out of water...
|
| Ryan...
|
|
|
| "Stefan B Rusynko" wrote:
|
| > Before you add to the DB always check for duplicates during registration
| >
| > Use the same process as your Log in, But check for EOF first (no record found )
| >
| > <%
| > IF objRS.EOF THEN ' not a dupe
| > ' do your registration ADD routine here
| > ELSE ' is a dupe
| > ' send them back to start page again with different credentials
| > END IF
| >
| > %>
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > "Rhyno" <Rhyno@discussions.microsoft.com> wrote in message news:743CF593-1A7A-4F8C-A466-0712513E20B5@microsoft.com...
| > | Hi there
| > |
| > | I've created protected ASP pages in my website following instructions in
| > | article
http://support.microsoft.com/kb/825498
| > |
| > | Users are prompted to log on or register if they aren't already registered.
| > |
| > | The registration form is split over two ASP pages. The first page simply
| > | asks for email address, username and password and, on submit, posts to the
| > | second ASP page.
| > |
| > | The second page asks the user for contact details (name, address etc.)
| > |
| > | I would like the first page of the registration to check the database to
| > | find if there are any records with the same username or email address before
| > | posting to the second page.
| > |
| > | If the username or email address already exists, I want to return an error
| > | prompting the visitor to try another username or email address.
| > |
| > | I've set the properties of these fields in the access database to disallow
| > | duplicates. However, if a visitor enters a username or email address that
| > | already exists in the Access Database, the record is not added to the
| > | database but the user is unaware and can complete and submit the registration
| > | form.
| > |
| > | Any help would be greatly appreciated!
| > |
| > | Thanks in advance.
| > |
| > | Ryan
| >
| >
| >