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+unsubscr...@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.

Reply via email to