Welcome Guest, Not a member yet? Register   Sign In
calling functions within select (Active Record)
#1

[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
#2

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

[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




Theme © iAndrew 2016 - Forum software by © MyBB