Hi Seb, I just finished a full rewrite of the query generator a couple days ago, and it now correctly handles your condition, which has been added as a test case to the core regression tests. You can grab the new core from the 1.2 branch of SVN, or grab the latest nightly.
On Mar 21, 1: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 -~----------~----~----~----~------~----~------~--~---