Problem with DataAssist and ServerValiadion

I created a recordset to check for duplicate emails for a registration form. I then used DataAssist to add a single record to my database. Then I added a SA Server Validation to my page to check if security code matches CAPTCHA.

The order in the server behavior panels is as follow:
1) SA Server Validation
2) Recordset
3) Insert behavior

I tested the page and it worked fine. I then added $totalRows_rsCheckEmail to my current SA Server Validation to check for duplicate emails. Now the form will not insert the record to my database, even when I try using an email address that is not in my database.

M' I require to have two SA Server Behaviors? One for checking email duplicates and one for checking Security Code.

the code order:

1) SA Server Validation
2) Recordset
3) Insert behavior


needs to be:
1) Recordset
2) SA Server Validation
3) Insert behavior


the problem is that you are using the $totalRows_rsCheckEmail variable in the server validation, before it has been created.


with the code in the current order:
1) SA Server Validation - uses $totalRows_rsCheckEmail varaibel
2) Recordset - creates $totalRows_rsCheckEmail varaible
3) Insert behavior

you can see that the $totalRows_rsCheckEmail variable is being used before it is created.


the recordset needs to come first so that the $totalRows_rsCheckEmail variable exists when the Server validation code tries to use it.

Thanks for the fast response. Form is working great now.