mssql (microsoft sql) bug or ......

[marconi8]

mssql = microsoft sql server

i have noticed some strange situation working with mssql, look please at this simple example

simple example ==========================================
$myServer = "localhost";
$myUser="sa";
$myPass="sa";
$myDB="DATABASE";

$db1 = @mssql_connect('localhost',"sa","sa");
mssql_select_db($myDB,$db1);

$sp = mssql_init("STORED_PROCEDURE",$db1);
$rs1 = mssql_execute($sp);

$rs2=mssql_query("SELECT * FROM TABLE");

while($frs2=mssql_fetch_array($rs2))
{
echo "<br>".$frs2["ID"];
}

while ($frs = mssql_fetch_array($rs1))
{
echo "<br>".$frs["A_TYPE"];

}

now problem description........

this simple example works good when STORED_PROCEDURE ( see in $rs1 execute statement ) has only one recordset returned in query

but when STORED_PROCEDURE has more than one recordset returned in one query i get the error like

mssql_query() [function.mssql-query]: Query failed in....

maybe someone have this situation in work, maybe someone can hep me,

big thanks for your help

[tomhath]

I've never tried what you're doing from php, but from ADO I believe the proc would return an array of recordsets.

All I can suggest is to try declaring $rs1 as an array.

[marconi8]

<?php
include('../../www/dsclubs/lib/mssql_lib/adodb-errorhandler.inc.php');
include('../../www/dsclubs/lib/mssql_lib/adodb.inc.php');
include('../../www/dsclubs/lib/mssql_lib/tohtml.inc.php');

$mssql_connection=NewADOConnection("mssql");
$mssql_connection->Connect('localhost','sa','sa','DSCLUB');

$mssql_connection->debug=1;
$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;

$sp = $mssql_connection->PrepareSP('P_DOSKA_NEDVIG_CAS_GET');
$value=10;
$rs = $mssql_connection->Execute($sp);

while($frs=$rs->FetchNextObject())
{
echo "<br>".$frs->A_TYPE;
}

/
at this place
$mssql_connection->Execute("SELECT FROM DOSKA_RUBRIKA");
returns to me an error if $rs have multiple recordset in one query
*/

$rs2=$mssql_connection->Execute("SELECT * FROM DOSKA_RUBRIKA");
while ($frs2=$rs2->FetchNextObject())
{
echo "<br>|||".$frs2->ID;
}

$mssql_connection->Close();
?>