Active Record and Database Functions

[eluser]Jazmo[/eluser]
In case you have db_prefixes set in config.php
this

Code:

$this->db->select("C.id, C.name, COUNT(E.id)", FALSE);

will translate to

Code:

SELECT C.id, C.nimi, jbb3_COUNT(E.id)

where jbb3_ is my table prefix.

Is there a workaround somewhere? Or do i need to fall back to $this->db->query ?