Additionally, could any one else using the latest SVN try that out...
to see if i'm just freaking out...?!
Thx!
On Mar 21, 2:58 pm, "Seb" <[EMAIL PROTECTED]> wrote:
> 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/attentionhttps://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 [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
-~----------~----~----~----~------~----~------~--~---
