This is a registration form so I would like it to check to be sure the same e-mail address isn't already in the database. I would like to do this for the password column too.
If the email address or password is already in the database then I would like an error message to display, something like "password is already in use, please enter a different password" and the same thing for the e-mail address.
I saw in the thread that I mentioned where Jason said you could apply two validations on the same field and I've been trying that but haven't been able to get it to work yet.
Here's what I was doing:
I opened the current WA Server Validations.
Used my page submission as the trigger
Used the number setting
set minimum to -1
set maximum to 0
Server validation - I'm not clear which I should choose here, the folder with my page name or the WA Validated folder.
When i do it that way the "insert" fails and the page reloads without the data that was entered.
By the way, I did follow the instructions in that thread and made two additional recordsets, one for the e-mail and one for the password and I'm not sure if I still need those or not when doing it this way.
Thank you so much for your help, I'm falling way behind on my March 1st launch date so this is really helping me out.