Active Records and comma char |
[eluser]Unknown[/eluser]
I've stumbled upon this error while building page listing query Code: $this->db->select("CONCAT('page,',alias,'.html') as link, name", FALSE); Code: alias:page, start.html // notice the space char after comma Code: $this->db->select("CONCAT(TRIM('page,'),alias,'.html') as link, name", FALSE); So here is my bug report Regards, aln
[eluser]WanWizard[/eluser]
No, the manual states: Quote:If you set it to FALSE, CodeIgniter will not try to protect your field or table names with backticks. This is useful if you need a compound select statement. This works, and is not the problem. The bug is that the code interprets the comma as a field separator. It splits the string to check for table names so it can add a table prefix. This breaks the CONCAT.
[eluser]Mark Croxton[/eluser]
See: http://codeigniter.com/bug_tracker/bug/8663/ |
Welcome Guest, Not a member yet? Register Sign In |