#37890 [Com]: retrieving float datatype - similar to #19916
| From: | frediano dot ziglio at vodafone dot com | Date: | Fri, 20 Oct 2006 15:07:31 +0000 |
| Subject: | #37890 [Com]: retrieving float datatype - similar to #19916 | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-103799@lists.php.net to get a copy of this message | ||
ID: 37890
Comment by: frediano dot ziglio at vodafone dot com
Reported By: krishimeena at yahoo dot com
Status: Open
Bug Type: MSSQL related
Operating System: UNIX
PHP Version: 5.1.5CVS
New Comment:
Which platform are you using?
freddy77
Previous Comments:
------------------------------------------------------------------------
[2006-06-22 16:54:03] krishimeena at yahoo dot com
Description:
------------
We upgraded php4 to php5 and this same listed bug has cropped up. When
I query and retrieve a float or REAL datatype with a combination of
some varchar 50 datatype I see an error exit bus signal error 10. As
soon as I change the sequence of the retrieval of the data it works
fine.
Please refer to bug #19916, it appears to be the same issue.
Reproduce code:
---------------
This code does not work:
$SQL = "BEGIN SELECT tblfirsttable.varCharData ,
tblSecondtable.floatData from tblfirsttable, tblSecondtable";
$query_rslt = mssql_query($SQL);
$numrows = mssql_num_rows($query_rslt);
echo $numrows;
However if I swap the retrieval of float value first nad then the
varchar it works fine:
$SQL = "BEGIN SELECT tblSecondtable.floatData,
tblfirsttable.varCharData from tblfirsttable, tblSecondtable";
$query_rslt = mssql_query($SQLl);
$numrows = mssql_num_rows($query_rslt);
echo $numrows;
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=37890&edit=1