Jump to content

How to get to additional recordsets when a Stored Procedure returns more than one


QueryDawg

Recommended Posts

Hello,

 

I'm have several Stored Procedures in an MSSQL database that return multiple recordsets but I can't seem to find out how to access the second (and third) result sets.

 

 

So my stack looks something like

 

Mac OSX > PHP 5.4.24 > unixODBC/freeTDS > (remote) Microsoft SQL Server 2008

 

 

I'm doing something like this which works fine for SQL Statements or SP's that return a single recordset:

 

$conn = odbc_connect('my_data_source','my_login','my_password');

$rs = odbc_exec($conn,"exec MY_STORED_PROCEDURE_NAME"); // <- this returns 3 recordsets

 

manipulating $rs works fine for the first recordset returned. I assume $rs is "hidding" results 2 and 3? Maybe?

 

Thanks in advance,

 

 

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.