I've been pulling my hair out for a few days trying to find out
whether I was doing something wrong...
I have this 'records filtering' in place:
[code]
$filter = "LOWER(Article.title) LIKE 'a%'";
// ... more stuff... then I do a...
$this->Article->findAll($filter);
[/code]
Now in version 1.2.0.4605, the generated sql is: (field list stripped
down to * for argument sake)
SELECT * FROM `articles` AS `Article` WHERE LOWER `Article`.`title`)
LIKE 'a%' ORDER BY `Article`.`title` ASC LIMIT 10
Notice how the first '(' for the MySQL LOWER function gets stripped
off? obviously, that's not valid SQL.
My question is... is that something I'm doing wrong from 4605 or is
this a bug.. (the same code use to work like a beauty in previous
releases.
Can anyone comment that?
I've raised a ticket last week.. with no feedbak/comment/log/attention
https://trac.cakephp.org/ticket/2256
Cheers,
Seb.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
