php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #30687 Second read attempt on memo (LONGCHAR) fields via ODBC fails
Submitted: 2004-11-04 17:44 UTC Modified: 2005-03-15 01:00 UTC
Votes:4
Avg. Score:4.5 ± 0.9
Reproduced:4 of 4 (100.0%)
Same Version:1 (25.0%)
Same OS:1 (25.0%)
From: albin at kth dot se Assigned:
Status: No Feedback Package: ODBC related
PHP Version: 5CVS-2004-11-04 (dev) OS: Windows XP Pro SP2
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: albin at kth dot se
New email:
PHP Version: OS:

 

 [2004-11-04 17:44 UTC] 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: 

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-03-07 21:59 UTC] 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


 [2005-03-15 01:00 UTC] php-bugs at lists dot php dot net
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".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 21 12:01:31 2024 UTC