From: [EMAIL PROTECTED]
Operating system: Windows XP Pro
PHP version: 4.2.3
PHP Bug Type: MSSQL related
Bug description: Problems with smallmoney datatype
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 bug report at http://bugs.php.net/?id=19588&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=19588&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=19588&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=19588&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=19588&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=19588&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=19588&r=support
Expected behavior: http://bugs.php.net/fix.php?id=19588&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=19588&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=19588&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=19588&r=globals
