Unique DB value validation not working
I have 2 values that I need to keep unique, user email and user screen name. I have tested both separately and got 2 surprises:
1: I expected page to show the "show if" regions for each validation failure. The other form element validations are working fine, but they are different validation types.
2: I will later set up DB to keep these columns unique, but each new record that I expect to be caught by the validation are each loading in the users tables.
I had this problem once before and was able to correct by removing and then adding validations, it's not letting me off so easy this time.
I am using Mac 10.7.3, DW5.5, and the latest version of Security Assist 2. SA 2 was the last extension installed.
I have attached a zip of the file I am working with. I will be creating a similar page for user updates later, if there is anything that I should be looking for, please let me know in case this happens again.
Thanks for the assistance,