#37900 [Opn->Fbk]: NULL values on a first record

From: Date: Thu, 26 Jul 2007 15:32:30 +0000
Subject: #37900 [Opn->Fbk]: NULL values on a first record
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-115472@lists.php.net to get a copy of this message 
 ID:               37900
 Updated by:       jani@php.net
 Reported By:      ovendrell at oip dot jazztel dot es
-Status:           Open
+Status:           Feedback
 Bug Type:         ODBC related
 Operating System: Linux
 PHP Version:      5.1.4
 New Comment:

Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows (zip):
 
  http://snaps.php.net/win32/php5.2-win32-latest.zip

For Windows (installer):

  http://snaps.php.net/win32/php5.2-win32-installer-latest.msi

And try using the PDO ODBC instead. It has been reported to work much
better..


Previous Comments:
------------------------------------------------------------------------

[2006-06-23 10:10:18] ovendrell at oip dot jazztel dot es

Description:
------------
I work with this environment:
* OS: Linux
* Web server: Apache 2.0
* DB server: Microsoft SQL server (7.0 or 2000)
* PHP 5.1.2

I execute a query with odbc_query() function. when the first record
result has a NULL value in a field, the next record that doesn't has a
NULL value in the same field doesn't return the correct value. It
returns unrecognizable chars. 

Reproduce code:
---------------
$res = odbc_exec ($bd, "SELECT Id, Num, Obs FROM publicacions");
odbc_result_all ($res);

-----------

$res = odbc_exec ($bd, "SELECT Id, Num FROM publicacions");
while (odbc_fetch_row ($res))
     echo odbc_result ($res, "Id")." ".odbc_result ($res,
"Num")."
".odbc_result ($res, "Obs")."<br>";



Expected result:
----------------
Id   Num   Obs
--------------
1    NULL  NULL
2    NULL  comment
3    23    NULL
4    45    aaaaa
5    NULL  bbbb
6    12    ccccc


Actual result:
--------------
Id   Num   Obs
--------------
1    NULL  NULL
2    NULL  èH@èH@
3    ˆèH@  NULL
4    45    aaaaa
5    NULL  bbbb
6    12    ccccc



------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=37900&edit=1

Thread (3 messages)

« previous php.bugs (#115472) next »