SecurityAssist registration page not validating correctly

Hello,

I used SecurityAssist to Create Security Pages with the wizard. A few strange things happened with the registration page:

1) The post variables were not set correctly for two of the fields in the Insert Record behavior. This was easy enough to fix by clicking on the behavior in the panel and correctly setting the bindings manually.

2) The bigger issue is that the form validation is not working correctly. When I attempt to register twice with the same email address and/or scout name (which is not allowed), it still redirects to my success page without any warnings or notes even though it does not enter data into the database. Right now I have it hooked up to a simple page that echos the email, scout name and hometown by taking the session variable that should be set by the registration form and using it to create a recordset of that data. When this failure happens, I get a message that I have an error in my SQL syntax because I am assuming that the session variable has been unset.

I am attaching the php file that was generated for the registration page. Any help would be greatly appreciated!

Thank you!

This looks like it should work. Please send a url and FTP access for testing and I'll be able to debug it and figure out why the validation isn't working properly.

Thanks - sending now.

The issue was with the key value being set to the session variable value in the server validation.

That setting is only used on update pages to allow the user to set the same value of their existing record, since it is getting overwritten anyway.

In your case the second registration was being allowed with the same email because the validation thought that was the record being overwritten, so it allowed it to pass.

The error was an invalid duplicate key error when the insert tried to process.

I fixed the problem by updating the server validations unique database value server behaviors and set the Key value to 0 (zero) since that will never exist. That is the right way to use it on insert pages.

Thank you so much for your help!

Thank you for your help! I think Dreamweaver accidentally overwrote what you did when I synced my local files because I still get the same error. Please let me know where I can find this server validations unique database value in the code so that I can set the key value to 0.

Sorry for the trouble and thanks again!

Just go to the server behaviors panel and click on your Server Validations server behavior. Then select the unique value validation from the list and click edit. You should see the unique id value field there and can update it to zero.

If you can't find it, please attach the page you are working on and I can tell you the line of code that needs to be updated.

Thanks, Ray - I think I found it and it seems to be working now. I appreciate your help!