Re: (My)SQL functions in 1.2.0.4605alpha
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
-~--~~~~--~~--~--~---
Re: (My)SQL functions in 1.2.0.4605alpha
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
-~--~~~~--~~--~--~---
(My)SQL functions in 1.2.0.4605alpha
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
-~--~~~~--~~--~--~---
Re: (My)SQL functions in 1.2.0.4605alpha
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
-~--~~~~--~~--~--~---
