Welcome Guest, Not a member yet? Register   Sign In
Multiple Result set Issue in CI
#1

[eluser]Unknown[/eluser]
This is a bit different from what other users have faced in similar topics.

I have a stored procedure that I want to execute. I am trying to execute another query (that returns a count) after the procedure in CI, but CI returns the following error for not getting mysqli_result object.

Fatal error: Call to a member function num_rows() on a non-object

If the procedure execution is the last db statement in my code, everything works fine. But when I try to execute even a simple query after that, CI returns the error.

CI seems to freeze the resultset once a procedure is executed. I dont understand what prompted the CI developers to do that. I tried a simple workaround by calling the db connect() again and then, the new query starts working. But I guess that's not the right way to do it.

Did anyone else face this issue? If so, can you please guide me how to resolve this in an optimum way


Messages In This Thread
Multiple Result set Issue in CI - by El Forum - 04-05-2010, 03:38 AM
Multiple Result set Issue in CI - by El Forum - 04-05-2010, 07:42 AM
Multiple Result set Issue in CI - by El Forum - 04-05-2010, 08:01 AM



Theme © iAndrew 2016 - Forum software by © MyBB