#19588 [Opn->Fbk]: Problems with smallmoney datatype

ID: 19588 Updated by: iliaa@php.net Reported By: falk@surrounded.de -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows XP Pro PHP Version: 4.2.3 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2002-09-25 04:37:25] falk@surrounded.de Information as of phpinfo(): PHP Version 4.2.3 System Windows NT 5.1 build 2600 Build Date Sep 6 2002 10:38:51 Server API CGI Debug Build no Thread Safety enabled mssql MSSQL Support enabled Library version 7.0 Directive Local Value Master Value mssql.allow_persistent On On mssql.batchsize 0 0 mssql.compatability_mode Off Off mssql.connect_timeout 5 5 mssql.datetimeconvert On On mssql.max_links Unlimited Unlimited mssql.max_persistent 10 10 mssql.min_error_severity 10 10 mssql.min_message_severity 10 10 mssql.textlimit Server default Server default mssql.textsize Server default Server default mssql.timeout 60 60 Zend Optimizer installed _ENV["SERVER_SOFTWARE"] Microsoft-IIS/5.1 _ENV["PROCESSOR_IDENTIFIER"] x86 Family 6 Model 4 Stepping 2, AuthenticAMD Running with MS SQL 7.0 Desktop Edition (I don't know whether this appears with MS SQL 2000). ****** Report: When selecting more than a small amount of rows (approx. 10) using mssql_query from a table including a smallmoney column, the script will immediately abort execution. This problem does not appear when using decimal(9,2) columns instead of smallmoney. Thus, a possible workaround for me was to CAST the smallmoney-column to decimal ("SELECT CAST ( value decimal(9,2))" instead of "SELECT value"). TIA for your time, best wishes, Falk ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19588&edit=1