Duplicate Login
Hello,
Is there a function in SA that can check for duplicate login (email)
Hello,
Is there a function in SA that can check for duplicate login (email)
the registration page created by the security assist wizard will add the Dreamweaver check new User name behavior to the page to accomplish this.
There is not a Security Assist replacement behavior, but it is possible to accomplish using the a recordet and the Server Validation included in CSS Form builder.
1) Create a recordset that is set to filter the email column on the email form element.
2) Open the server behaviors panel and click the plus button, select WA Validation Toolkit -> Server Validations
3) Choose number validation
4) Enter "$totalRows_RecordsetName" (where RecordsetName is the name of the recordset created in step one), without the quotes, for the server variable, then click the plus button to add it.
5) In the number validation configuration screen, set the minimum to -1 and the maximum to 0.
Aside from having a unique username, that SA makes sure is distinct...
One doesn't realize how important it is to have a unique email as well.
If everyone had the same email in a db...when one uses the Email Forgotton password...
Throws an error....
Anyway, I tried using what you suggested and it worked at first, and after repeating testing... It just redirects to the taken.php page. Even though I am registering with a
unique email address.
Would appreciate if you would look at a couple pieces of code. And let me know what I have wrong. ;)
I have attached a helpme.php which just includes the code in the header.....
Any help would be greatly appreciate!
the first problem i see is that the code for the rsEm recordset is after the validation code.
It needs to be moved so that the rsEm recordset is created before validation occurs.
The other issue I see is that the rsEM recordset is set to filter on the VisitorEmail Quesrystring variable, when it should be using the VisitorEmail POST variable.
I moved the code as you suggested, and it doesn't validate.
It allows duplicate entry of email address.
I attached a copy of code with your suggested changes.
Do I have to bind this to the form field ?
Thank you for your help ! :)
looking at the insert record code, it looks like the email form element is named "email"
you have the recordset setup to filter on a form element named "VisitorEmail".
change that to filter on the "email" form element instead.
Thank you for all your help. !
I really do appreciate it. :)
glad to hear it is working.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.