Re: Validate if not between

2013-11-19 Thread Salines
Thanks for your reply, exactly, it is a query that has to be performed during the validation, in order to check the validity of data entry. My mistake, the query must be simple BETWEEN Dana utorak, 19. studenoga 2013. 11:03:06 UTC+1, korisnik Benjamin Chéré napisao je: > > Hello, > I think it'

Re: Validate if not between

2013-11-19 Thread Benjamin Chéré
Hello, I think it's not a validation rule, your query is a search condition $this->Publisher->find ('all', array( 'fields' => array('pub_name', 'country', 'pub_city', 'estd'), 'conditions' => array('OR'=>array('YEAR(estd) <' => 2010, 'YEAR(estd) >' => 2013)) )); Le lundi 18 novembre 2013 23

Validate if not between

2013-11-18 Thread Salines
Hi, folks Is there any validation rules that check sent data does not exist between two dates? Or need to make a custom validation method? If there is no data between two dates validation must return TRUE or FALSE if it exists. Syntax as follows SELECT pub_name, country, pub_city, estd FROM p