ID: 24697
Updated by: [EMAIL PROTECTED]
Reported By: tty3000 at hotmail dot com
-Status: Open
+Status: Feedback
Bug Type: ODBC related
Operating System: win 2000
PHP Version: 4.3.2
New Comment:
I'm not quite sure I follow the bug you're reporting here. Can you
(with another ODBC application) get the results you're expecting? I
don't see how a query like that can fail as it's upto the logic of the
backing DB and not PHP to return the result set.
Previous Comments:
------------------------------------------------------------------------
[2003-07-17 20:50:59] tty3000 at hotmail dot com
Description:
------------
odbc can not return accurate result when we handle excel file use
odbc.
In excel file,we handle "NUMBER" nor "VARCHAR" ,this question appear.
we find ,this question appear when "0878-13420987" or
"0878_13420987".
Reproduce code:
---------------
$user = '';
$pass = '';
$host = 'customerxls';
$phptype='odbc';
//database name in excel
file��[main],[con_data],[con_person],[detail_data]
$dsn = "$phptype://$user:[EMAIL PROTECTED]";
$type=main;
[EMAIL PROTECTED]($host,"","");
$query="select a,b,d from $type";
[EMAIL PROTECTED]($connection,$query);
$query_count="select count(*) from $type";
echo "<br>".$query."<br>";
$col=count($title_array);
for($i=0;$i<$col;$i++)
echo $title_array[$i]."\t";
echo "<br>";
while (@odbc_fetch_row($result)){
echo
odbc_result($result,a)."<---->".odbc_result($result,b)."<---->".odbc_result($result,y)."<br>";
//echo $row[0]."<br>";
}
Expected result:
----------------
1.0<---->China<---->3395
2.0<---->China<---->13308
2.0<---->China<---->
Actual result:
--------------
1.0<---->China<---->3395
2.0<---->China<---->13308
3.0<---->China<---->
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24697&edit=1
