thanks!! Maybe the book is outdated or just a typo.
On Oct 6, 12:07 pm, Miles J <[email protected]> wrote:
> Almost there, the operators go in the array index, not the value.
>
> return $this->find('all',array(
>
> 'conditions'=>array(
>
> 'DATE(Post.date) >'=> $date,
> 'DATE(Post.date) <'=> $end_date
>
> )));
>
> On Oct 6, 8:52 am, "[email protected]" <[email protected]>
> wrote:
>
> > I am learning cake using a book, which has been great so far, but I am
> > having problems with one example of the book when it uses the "greater
> > than" and similar operators in a query...
>
> > here's what the books says:
>
> > return $this->find('all',array(
>
> > 'conditions'=>array(
>
> > 'DATE(Post.date)'=> '>'.$date,
> > 'DATE(Post.date)'=>'<'.$end_date
>
> > )));
>
> > here's what cake will query:
>
> > SELECT `Post`.`id`, `Post`.`name`, `Post`.`date`, `Post`.`content`,
> > `Post`.`user_id`, `User`.`id`, `User`.`name`, `User`.`email`,
> > `User`.`firstname`, `User`.`lastname` FROM `posts` AS `Post` LEFT JOIN
> > `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE DATE
> > (`Post`.`date`) = ' < 2009-12-31 23:59:59'
>
> > You can see at the end of the query that cake doesn't recognize the
> > "<" or the ">" operators... so it just adds the "=" and then the "<"
> > as a string. I am using the latest cake version.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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
-~----------~----~----~----~------~----~------~--~---
