Server validations not working as expected

Hello,

I'm trying to check to see whether a user exists before inserting it to the database.

I have taken the below steps.

1: created a query that checks to see whether the user exit
2: Created a WA server validation
3: Created a Show If Validation
4: Also, updated other fields to ensure if values in others are entered and username exists, the data is still there and users don't have to input again.

What's happening is that it looks like the server validations work but;
1: Data in other fields are being cleared
2: The server validation message stays even though I clear the page or navigate away from the page.

What am I doing wrong? See attachment?

It looks like you have number validation on a blank value. You should be validating form element values.

The form element values on the page should be bound to the "validated field" bindings. You have them bound to the form post values.

Please correct those two issues and include a copy of the updated page in a reply if you continue to have issues.

Thank you, Ray.

I did what you indicated but ran into another issue.

When I have the code, as is in the attachment, the validation works but the insert doesn't work when I put in a unique username. The page just refreshes.

Now, when I put the insert block of code above the Validation code which starts at Line 50, the insert works and my page breaks with a message that says, SQL error.

It looks like you have Numeric validation not Unique Value in Database validation set up for the username. I think you have the wrong type of validation set up. If you turn on Debug in your queryobj.php file it should give you a better message when the insert fails.

Thank you Ray.
Made the changed and re-organized the insert and validation statements and it works.