#33284 [Fbk->Csd]: CGI Error with mssqlselect
ID: 33284
User updated by: peter dot bernholt at hec dot de
Reported By: peter dot bernholt at hec dot de
-Status: Feedback
+Status: Closed
Bug Type: CGI related
Operating System: Windows XP
PHP Version: 4.3.11
New Comment:
Thank you,
With the new Version it works fine..
Regards,
Peter
Previous Comments:
------------------------------------------------------------------------
[2005-06-11 15:21:02] sniper@php.net
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
------------------------------------------------------------------------
[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
Thread (3 messages)