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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.
