calling functions within select (Active Record)

calling functions within select (Active Record) - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: calling functions within select (Active Record) (/showthread.php?tid=18424)

calling functions within select (Active Record) - El Forum - 05-06-2009

[eluser]gRoberts[/eluser]
Hi all,

Could be related to the following bug: http://codeigniter.com/bug_tracker/bug/7144/

Active Record prefixes functions within the select with the DBPrefix.

i.e

Code:
$this->db->select('sr.*, ifnull(sgr.RoleID, -1) != -1 as ShowActive', false);

produces

Code:
SELECT sr.*, dev_ifnull(sgr.RoleID, -1) != -1 as ShowActive FROM

Thanks

calling functions within select (Active Record) - El Forum - 05-06-2009

[eluser]Thorpe Obazee[/eluser]
<snipped>

calling functions within select (Active Record) - El Forum - 05-07-2009

[eluser]gRoberts[/eluser]
A solution to my problem was found.

http://ellislab.com/forums/viewreply/574946/

Thanks to BargainPH...

May still need looking into?

Thanks