Monday, November 18, 2013

Validate if not between

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.

No comments: