MSSQL 2000's 'real' type kills php
| From: | Jerome Houston | Date: | Tue, 14 May 2002 00:51:54 +0000 |
| Subject: | MSSQL 2000's 'real' type kills php | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-97443@lists.php.net to get a copy of this message | ||
Hi,
i'm working on a win2k server running php 4.1.1 accessing MSSQL server 2000 on a win2k server.
i've got a problem with a table that has 'real' numbers in it.
<database snippet>
code inventory name PRC01 2.33 Prince Brand ChipsFCA13 9.9999934E-2 Frozen Calamari </database snippet> when i mssql_query("select * from products"); or, more specifically mssql_query("select inventory from products where code = 'FCA13'"); BOOM! php crashes, and i get a pop-up window in MSIE that says, "IE cannot open the site ...... the connection with the server was reset" but mssql_query("select * from products where code = 'PRC01'"); works like a charm..... granted 9.9999934E-2 isn't an actual number for inventory, it should be 0.10 . BUT, i can't help that. my application is not the only one that uses this data. this happens with various numbers that have high precision. anyone run into this before? any suggestions? thanks VERY much in advance, jerome _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com