#30687 [Fbk->NoF]: Second read attempt on memo (LONGCHAR) fields via ODBC fails

ID: 30687 Updated by: php-bugs@lists.php.net Reported By: albin at kth dot se -Status: Feedback +Status: No Feedback Bug Type: ODBC related Operating System: Windows XP Pro SP2 PHP Version: 5CVS-2004-11-04 (dev) New Comment: No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". Previous Comments: ------------------------------------------------------------------------ [2005-03-07 21:59:04] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip ------------------------------------------------------------------------ [2004-11-04 17:44:13] albin at kth dot se Description: ------------ There seems to be a problem reading Memo-fields (ODBC-type LONGCHAR) from an MS-Access database via ODBC... The first attempt is successfull, but if you try to read the same field again from the same result-set you get nothing. Reading non-memo-fields multiple times works OK. Reproduce code: --------------- $db = odbc_connect('DATABASE','XXXX','XXXX'); $res = odbc_exec($db, "SELECT Body FROM Letters WHERE LetterID = X"); echo "First attempt: ".odbc_result($res, 'Body'); // displays the letter body echo "Second attempt: ".odbc_result($res,'Body'); // displays nothing Expected result: ---------------- First attempt: [Letter body] Second attempt: [Letter body] Actual result: -------------- First attempt: [Letter body] Second attempt: ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=30687&edit=1