Welcome Guest, Not a member yet? Register   Sign In
Call Stored Procedure
#1

[eluser]Hugo Tessaro[/eluser]
Hi all, im trying to call a stored procedure in MySql...

When I use $this->db->call_function('func_name'); MySql dont receive the query...
I tried $query = $this->db->query("call stored_procedure_name()"); with db driver 'mysql' but function return FALSE to variable, but when I change db driver to MySqli, works correctly, but all times I refresh page, a new connection is used...

log: http://img573.imageshack.us/img573/9906/sqllog.jpg

so... what is the better way to call stored procedure in CI? what driver I use?

Thanks!
#2

[eluser]Hugo Tessaro[/eluser]
nobody risks?




Theme © iAndrew 2016 - Forum software by © MyBB