I've had the same problems with my own functions so you aren't crazy
if that helps.
On Mar 21, 12:12 am, "Seb" <[EMAIL PROTECTED]> wrote:
> 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 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
-~----------~----~----~----~------~----~------~--~---
