Welcome Guest, Not a member yet? Register   Sign In
Quick question regarding where_in/where_not_in Active Record
#2

[eluser]Armchair Samurai[/eluser]
Unlike where(), you can't add FALSE as a third parameter to prevent the escaping of variables (unless it's an undocumented feature - I haven't checked the source) with where_not_in(), so best to write out the subquery if you use AR.
Code:
$this->db->where('table.id NOT IN', '(SELECT other.id FROM other)', FALSE);


Messages In This Thread
Quick question regarding where_in/where_not_in Active Record - by El Forum - 01-28-2009, 05:09 PM



Theme © iAndrew 2016 - Forum software by © MyBB