ID: 48908
User updated by: aaron at aarondm dot com
Reported By: aaron at aarondm dot com
Status: Open
Bug Type: MSSQL related
Operating System: ArchLinux
PHP Version: 5.2.10
New Comment:
I have run the same query on Windows Server 2003 (Enterprise Edition)
and this does not seem to be an issue. On windows it is able to fetch
the column data with no problems.
Previous Comments:
------------------------------------------------------------------------
[2009-07-13 19:54:44] aaron at aarondm dot com
Description:
------------
When trying to query a table, with a column whos type is
'smalldatetime', the code will result in a 500 Internal Error
Reproduce code:
---------------
Create table with the following columns
----------------------------------------
MY_TABLE
----------------------------------------
|(int) ID | (smalldatetime) MY_EXAMPLE |
----------------------------------------
Run:
$result = mssql_query("SELECT MY_EXAMPLE FROM MY_TABLE");
When you run that, you will get a:
500 Internal Server Error
On ArchLinux/Windows
Expected result:
----------------
No 500 Internal Server Error.
Should be able to query the database with no problems
Actual result:
--------------
500 Internal Server Error
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=48908&edit=1
