MS SQL Stored proc returns multiple recordsets |
[eluser]btwong[/eluser]
I have a stored proc on a MS SQL server, that returns 3 recordsets. How can i differentiate between each record set? (i want 1 field from the first recordset, and all of the second recordset). Any ideas?
[eluser]bretticus[/eluser]
You probably call mssql_next_result(). But I doubt this is possible using CI's ActiveRecord.
[eluser]bretticus[/eluser]
You might wanna anaylze the adodb php library for how they accomplish this too: http://phplens.com/adodb/reference.funct...rdset.html Good luck
[eluser]btwong[/eluser]
CI won't allow that call - mssql_next_result($query). I will now suss out the adodb. Thanks heaps for your help. If i find anything useful, i will be sure to post back here. thanks again
[eluser]WanWizard[/eluser]
Isn't that a bit drastic? Nobody's stopping you from calling this function outside of CI's AR system, or to add the method to CI's AR library. That seems to me a lot easier than switching to adodb...
[eluser]btwong[/eluser]
What is the AR system that you are talking about? Is the mssql drivers php files, or is it something else? ------------ sorry, AR = active record. i have been using the below: Code: do { i am attempting to play around with it, and i am getting some results. |
Welcome Guest, Not a member yet? Register Sign In |