Oleg, instead of doing a name/value pair, try just a string
mixed in with your other conditions. You may want to add quotes
around the date as shown below if you ever need to use hh:mm:ss
as any space will likely confuse the sql interpreter at that time.
...
"property" => "Usr.birthday",
'condition >="' . date('d.m.Y') . '"',
"type" => "date"
...
On 9/27/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Hi all,
>
> I'm working with Pagination and Cake PHP.
> To filter Pagination entry's I'm using the following filter Criteria.
>
> $criteria = array (
> ...
> "Filter.birthdayFrom" => array (
> "property" => "Usr.birthday",
> "condition" => ">=" . date('d.m.Y'),
> "type" => "date"
> ),
> "Filter.birthdayTo" => array (
> "property" => "Usr.birthday",
> "condition" => "<=" . date('d.m.Y'),
> "type" => "date"
> ),
> ...
>
> All other filter criteria for pagination working fine. But this two
> generates always a wrong selct string like:
> SELECT .... FROM Usr WHERE Usr.birthday = '15.08.1982' AND ....
>
> I need something like this:
> SELECT .... FROM Usr WHERE Usr.birthday >= '15.08.1982' AND ....
> but how can mange this.
>
> Do Cake support this art of criteria???
>
> Thanks
> Oleg
>
>
> >
>
--
--
Howard Glynn - Edinburgh, UK
[EMAIL PROTECTED] - email, google talk, facebook
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
