subtle gotcha using query bindings

[eluser]batteries[/eluser]
for complicated queries i build them first, too. to avoid this kind of situation.

also, why are you creating the key name 'roles' in:

Code:

$query = $this->db->query($sql, array(’roles’ => $roles));

?