PHP 4.0 Bug #6572: ODBC_result cannot fetch MEMO fields from MS Access
| From: | mischa at szeker dot ch | Date: | Wed, 06 Sep 2000 09:23:54 +0000 |
| Subject: | PHP 4.0 Bug #6572: ODBC_result cannot fetch MEMO fields from MS Access | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-32328@lists.php.net to get a copy of this message | ||
From: mischa@szeker.ch
Operating system: Win NT 4.0
PHP version: 4.0.1pl2
PHP Bug Type: ODBC related
Bug description: ODBC_result cannot fetch MEMO fields from MS Access
ODBC_result cannot fetch MEMO fields from MS Access
<?php $dsn = "szeker";
$user = "administrator";
$passwort = "";
$verbindung = odbc_connect($dsn, $user, $passwort);
$sql = "SELECT * FROM tGuestbook";
$ergebnis = odbc_exec($verbindung, $sql);
echo "<table>\n";
echo "<tr>";
echo "<td>";
echo odbc_result($ergebnis, "Name");
echo ",<br>\n";
echo "<a href=\"mailto:";
echo odbc_result($ergebnis, "Email");
echo "\">";
echo odbc_result($ergebnis, "Email");
echo "</a><br>\n";
echo odbc_result($ergebnis, "Date");
echo ",<br>\n";
echo odbc_result($ergebnis, "Time");
echo "</td>";
echo "<td>";
echo odbc_result($ergebnis, "Memo");
echo "</td>";
echo "</table>";
odbc_free_result($ergebnis);
odbc_close($verbindung);
?>
I always get the following error message when I run this script: Warning: SQL error:
[Microsoft][ODBC Driver Manager] Invalid cursor state, SQL state 24000 in SQLGetData in c:\program
files\apache group\apache\htdocs\szeker\new\guestbook.php on line 37
And I'm not the only one - in the language reference there is another user with exactly the
same problem. If I change the data type from Memo to Text, everything works fine. But I need more
than 255 characters in this field. Is there another possibility to query this field? Or will this
bug be fixed?