[eluser]gRoberts[/eluser]
Hi all,
I need to use functions such as ifnull within my select query but due to the fact that I have a database prefix, its failing.
i.e:
Code:
$this->db->select('sr.*, ifnull(sgr.RoleID, -1) != -1 as ShowActive', false);
produces an error:
Code:
SELECT sr.*, dev_ifnull(sgr.RoleID, -1) != -1 as ShowActive FROM
For some reason, its prefixing the functions with my database prefix.
Any idea's on how to get around this?
Cheers
Gav