Re: Validate if not between

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'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:38:35 UTC+1, Salines a écrit :

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 publisher

WHERE YEAR (estd) NOT BETWEEN 2010 AND 2013;

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.