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
-~----------~----~----~----~------~----~------~--~---
