close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Duplicate Login

Thread began 7/19/2010 4:11 pm by mark220932 | Last modified 7/30/2010 12:28 pm by Jason Byrnes | 1932 views | 7 replies |

mark220932

Duplicate Login

Hello,

Is there a function in SA that can check for duplicate login (email)

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

mustang_sally_85344510

Having problems using this throws error

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!

Attached Files
helpme.zip
Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

mustang_sally_85344510

made changes does validate

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 ! :)

Attached Files
helpmeRevised.zip
Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

mustang_sally_85344510

Thank You~ works GREAT now

Thank you for all your help. !
I really do appreciate it. :)

Sign in to reply to this post

Jason ByrnesWebAssist

glad to hear it is working.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...