Welcome Guest, Not a member yet? Register   Sign In
working w/stored proc that return multiple result sets

(This post was last modified: 12-07-2015, 02:41 PM by ozzy mandiaz.)

Huh  I've been working on converting an old dot net application to php/mysql and CI3. 

the dot net application is using mysql with a number of stored procedures that for the most part work just fine when called using $this->db->query("call xxxx()"); However, a number of those stored procs return multiple result sets that  are relatively simple to use in the dot net/c# environment. not so much using this particular db interface. or at least, that I've discovered. 

Any ideas or suggestions as to how to accomplish this?  I do know that I can do this within a loop using the mysql pdo interface. is this something I should use just for this particular situation?

please be kind, as I'm new to 3.x and never really encountered this  when learning 2.x.. 



And on the pedestal these words appear:
'My name is Ozymandias, king of kings:
Look on my works, ye Mighty, and despair!'
Nothing beside remains. Round the decay
Of that colossal wreck, boundless and bare
The lone and level sands stretch far away.

Messages In This Thread
working w/stored proc that return multiple result sets - by ozzy mandiaz - 12-07-2015, 09:27 AM

Theme © iAndrew 2016 - Forum software by © MyBB