Hi bakes!
Just upgraded to cake_1.1.18.5850 and some of my old distinct queries
failed.
Old query:
$posts = $this->findAll('Post.tag NOT LIKE ""', array('distinct
`Post`.`tag`'), 'Post.tag DESC');
Result query from Cake was:
Query: SELECT distinct `Post.`tag` FROM `cake_posts` AS `Post` LEFT
JOIN `cake_users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE
`Post`.`deleted` != 1 and `Post`.`tag` NOT LIKE "" ORDER BY
`Post`.`tag` DESC
As you can see the `Post.`tag` is parsed wrong..
But when i changed distinct to UPPERCASE it renders right:
New query:
$posts = $this->findAll('Post.tag NOT LIKE ""', array('DISTINCT
`Post`.`tag`'), 'Post.tag DESC');
Guess its nice to know ;-)
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
