#33284 [Opn->Fbk]: CGI Error with mssqlselect
| From: | sniper@php.net | Date: | Sat, 11 Jun 2005 13:21:03 +0000 |
| Subject: | #33284 [Opn->Fbk]: CGI Error with mssqlselect | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-80153@lists.php.net to get a copy of this message | ||
ID: 33284
Updated by: sniper@php.net
Reported By: peter dot bernholt at hec dot de
-Status: Open
+Status: Feedback
Bug Type: CGI related
Operating System: Windows XP
PHP Version: 4.3.11
New Comment:
Please try using this CVS snapshot:
http://snaps.php.net/php4-STABLE-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php4-win32-STABLE-latest.zip
Previous Comments:
------------------------------------------------------------------------
[2005-06-09 18:53:41] peter dot bernholt at hec dot de
Description:
------------
Hi all,
I am using PHP with IIS ,Windows XP and SQL Server 2000. The Function
mssql_query causes an error, when there is an result of an
Select-Statement (not true or false). Update, insert and delete works
fine. A select with an empty table is ok, true ("true").
I am not using the "header"-function!
Regards, Peter
Reproduce code:
---------------
$connection=mssql_connect($server,$username,$password);
@mssql_select_db($database,$connection) or die( "Unable to select
database");
$sqlquery="Select * FROM Tablename";
$result= mssql_query($sqlquery);
Expected result:
----------------
The Table contains one row, i would expect to get the result in
$result.
Actual result:
--------------
The specified CGI application misbehaved by not returning a complete
set of HTTP headers. The headers it did return are:
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=33284&edit=1