Welcome Guest, Not a member yet? Register   Sign In
Dotted char in query with dbprefix
#1

[eluser]Unknown[/eluser]
I have table prefix "ds_". When I execute this query:

Code:
$this->db->select('concat(id, ".") as id_dotted')
   ->where('parent < 10')
   ->get('categories AS c');

result is:

Code:
SELECT concat(c.path, `ds_"`.`")`
FROM (`ds_categories` AS c)
WHERE `parent` < 10

Naturally query don't work because dot is displayed (... `ds_"`.`")`.
This is a problem.

Do you have a solution?
Thanks.




Theme © iAndrew 2016 - Forum software by © MyBB