validation conflict

Hey Jason

I seem to have a conflict on the attached page.

First off, not sure if I have set up the validations correctly as havent used 2 before and have set up 2 different validations (should they be in one?)

The 2 validations I have are to check that the CompanyName field is not blank and to check it is a unique name.

On clicking insert (and leaving the CompanyName field blank) thewrong error is shown. It should show 'Company Name Required' but instead it shows the error if the company name is already being used....

Not sure what I have done wrong.

Many thanks

Jamie

  First off, not sure if I have set up the validations correctly as havent used 2 before and have set up 2 different validations (should they be in one?)  

yes, this is the problem, you should not be using 2 instances of the server validation behavior, you should one instance of the server validation behavior and define all of the validation in that one instance.

I had tried that but when insert button is pressed and the field is empty, both error messages show (when it should be just the required field one). if the field has content and is not unque, then only the uniw error message shows (as it should)

I have redone it again just now (and attach the file) and still get that same problem

That is the way the unique validation works, The unique validation does not allow for blank value, so if the valuer is left blank both the unique and required validation will occur.


i guess you could add an if statement around the line for the unique validation so it will only be processed if there is a value:

if((isset($_POST["TestimonialCompany"])) && $_POST["TestimonialCompany"] != "") {
$WAFV_Errors .= WAValidateUnique("PowerCMSConnection",$PowerCMSConnection,$database_PowerCMSConnection,"testimonial","TestimonialID","none,none,NULL","0","TestimonialCompany","',none,''","".(((isset($_POST["TestimonialCompany"]))?$_POST["TestimonialCompany"]:""))  ."",true,2);
}

ah ok thanks Jason

you're welcome.