False table prefix in sql select statement |
[eluser]uk81[/eluser]
I have another thing to discuss. I open a bug report for this (because for me it is truely a bug), but I am be "urged" to open a forum discussion on this. So we can discuss if it is a bug or not. Here is the full description what it is about: http://codeigniter.com/bug_tracker/bug/4432/ I set up only one little sql select (on a mysql db) and use the date_format() function inside the statement. The 2nd parameter for this function is the format string. I put one inside and it has dots in it. After using the db->select() function there will be my table-prefix (set up in the CI config) append on the front of the format-string. See and read the bug note, there is also a code-example. I does not try until now the last suggestion from Derek. Please write me your suggestions and ideas. Thanks.
[eluser]Derek Allard[/eluser]
Could you post your select statement here for reference? Did you add the second parameter to avoid CI's escaping?
[eluser]Unknown[/eluser]
I've a similar problem Code: $select = str_replace('$',$this->db->dbprefix, produces the following mysql error Quote:A Database Error Occurred The problem is that CI adds my table prefix to DATE_FORMAT although I set the the second parameter false in "$this->db->select($select, false);" Is this a bug? |
Welcome Guest, Not a member yet? Register Sign In |