php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #19588 Problems with smallmoney datatype
Submitted: 2002-09-25 04:37 UTC Modified: 2003-07-04 02:06 UTC
Votes:4
Avg. Score:2.8 ± 1.5
Reproduced:3 of 3 (100.0%)
Same Version:2 (66.7%)
Same OS:1 (33.3%)
From: falk at surrounded dot de Assigned:
Status: No Feedback Package: MSSQL related
PHP Version: 4.2.3 OS: Windows XP Pro
Private report: No CVE-ID: None
 [2002-09-25 04:37 UTC] falk at surrounded dot 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-12-23 04:07 UTC] falk at surrounded dot de
The mentioned release behaved unfortunately exactly the same, but the transferred data amount could be increased.
 [2003-02-21 11:09 UTC] jayc_lawrence at hotmail dot com
I have had problems with mssql 7.0 and the decimal function.
I have changed the scale and precision numerous times to find that the value does not change number of decimal places... however when i executed a similar query on an mssql 2000 box i found that the decimal function worked exactly as documented. Im not sure whether its an issue with mssql 7 or whether my db is botched.. however to me it appears this may be a mssql server side rather than a PHP issue..
Oh and you mention you are using msde.. why dont you try the same query in query analyser and see if it fails too?
Im aware you dont get enterprise manager with it, but if you have a mssql server licence you can use the enterprise manager from that for it i believe.
 [2003-07-04 02:06 UTC] sniper@php.net
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Oct 10 15:01:27 2024 UTC