#23434 [NEW]: multiple recordset in one query
| From: | marco_m at inbox dot lv | Date: | Thu, 01 May 2003 08:49:35 +0000 |
| Subject: | #23434 [NEW]: multiple recordset in one query | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-38874@lists.php.net to get a copy of this message | ||
From: marco_m at inbox dot lv
Operating system: Windows XP pro
PHP version: 4.3.1
PHP Bug Type: MSSQL related
Bug description: multiple recordset in one query
1) original code is:
=======================================================
$myServer = "localhost";
$myUser = "sa";
$myPass = "sa";
$myDB = "DB_NAME";
$db1 = @mssql_connect($myServer,$myUser,$myPass);
mssql_select_db($myDB,$db1);
$sp = mssql_init("STORED PROCEDURE",$db1);
$rs1 = mssql_execute($sp);
$rs2 = mssql_query("SELECT * FROM TABLE_NAME");
while($frs2=mssql_fetch_array($rs2))
{
echo "<br>".$frs2["ID"];
}
while ($frs1 = mssql_fetch_array($rs1))
{
echo "<br>".$frs1["A_TYPE"];
}
=======================================================
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....
--
Edit bug report at http://bugs.php.net/?id=23434&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=23434&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=23434&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=23434&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=23434&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=23434&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=23434&r=support
Expected behavior: http://bugs.php.net/fix.php?id=23434&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=23434&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=23434&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=23434&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=23434&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=23434&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=23434&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=23434&r=gnused