CodeIgniter Forums

Full Version: $this->db->query question
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

Hi there,
i have a problem, i use query binding for use procedures, like: $this->db->query("call addSomething(?,?);", array(true, 0));
But i have an problem, because the 'true', and '0' are inside of ' ', and with this mysql detect it like an string and not a boolean and someway to fix this? Or just have to write manual the params?

Or it's better use mysql convertions?

Best regards,

El Forum

Any query bindings are automatically escaped. There is currently no option to disable this. You'll either need to write out the query fully yourself, or choose an Active Record solution if one can be managed for what you need to do.