php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #17593 mssql_query doesn't fetch results properly
Submitted: 2002-06-04 06:38 UTC Modified: 2002-12-03 12:07 UTC
Votes:2
Avg. Score:4.0 ± 1.0
Reproduced:2 of 2 (100.0%)
Same Version:1 (50.0%)
Same OS:1 (50.0%)
From: alexp at mail dot lv Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4.2.1 OS: Win2k prof. SP2
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: alexp at mail dot lv
New email:
PHP Version: OS:

 

 [2002-06-04 06:38 UTC] alexp at mail dot lv 
It seems that mssql_query fails to get results properly after executing some arbitrary queries.

<?php
  mssql_connect(".","login","passwd");
  $r1=mssql_query("if object_id('tempdb..#abc') is not null drop table #abc");
  $r2=mssql_query("select * from sometable");
  $r3=mssql_query("select * from othertable");
?>

..causes..


Warning: MS SQL error: Attempt to initiate a new SQL Server operation with results pending. (severity 7) in d:\htdocs\t\bug.php on line 4

Warning: MS SQL: Query failed in d:\htdocs\t\bug.php on line 4

Warning: MS SQL error: Attempt to initiate a new SQL Server operation with results pending. (severity 7) in d:\htdocs\t\bug.php on line 5

Warning: MS SQL: Query failed in d:\htdocs\t\bug.php on line 5
----

First query is correct and executes properly (checked with SQL server profiler running). But 2nd,3rd..n-th fail to execute. Though if I comment out 1st one, others work ok. Another dirty hack to avoid these errors is to embed entire query in exec(""). But then temporary #tables won't be available in next queries.

I've found another similar bug in database, #9379. Using sql variables in query causes same weird behaviour...

In a few days I will test this script on Linux/apache/php/freedts connecting to same sql database and see if it works.

Any ideas?

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-12-03 12:07 UTC] fmk@php.net 
In PHP 4.3.0 you will be able to fix this problem by calling mssql_free_result($r1); after the first statement.

When you use if statements MSSQL server seams to hold the result (blocing for other statements) until the result is released.
 [2003-10-31 08:41 UTC] adimuraru at rdslink dot ro 
This error occurs when you try to send a new command to the server before all the results of the previous command on the same connection have been completely processed. A connection in mssql library used in php is single-threaded and synchronous; it can handle only one request to the server at a time.

So, if you want to pass multiple query  to a database make a single batch query(with multiple queries):
 $RS=mssql_query(select * from table1 select * from tabel2);
and use mysql_next_result to fetch all records.

After use result set make sure you  deallocate resources with mssql_free_result($rs) before make another request to sql server in the same script
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Fri May 09 09:01:26 2025 UTC