ID: 6421
Updated by: sbergmann
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Feedback
Bug Type: Unknown/Other Function
Operating system:
PHP Version: 4.0 Latest CVS (29/08/2000)
Assigned To:
Comments:
Have you tried a newer version of PEAR/DB, for instance the one that ships with PHP
4.0.5?
Previous Comments:
---------------------------------------------------------------------------
[2000-08-29 14:51:55] [EMAIL PROTECTED]
What does the following line in DB/common.php do ?
(line 182:) $stmt = (int)$this->prepare_maxstmt++;
I have to outcomment the line when I recall execute() on the same prepared query!
In the original code $realquery, in execute(), is set to the following string when
calling it again with the same prepared query...
[db_error: message="DB Error: invalid" code=-8 mode=return level=notice prefix=""
prepend="" append=""]
--------------------------------
example:
<?php
include("/usr/lib/php4/DB/pgsql.php");
$dsn = 'pgsql://127.0.0.1/web';
$db = new DB_pgsql();
$db->connect($dsn);
$stm = $db->prepare('SELECT * FROM pg_type WHERE typname = ? ORDER BY typname;');
$r1 = $db->execute($stm, array('_point'));
$r2 = $db->execute($stm, array('_bit'));
while($b = $db->fetchrow($r1)) {
echo $b[0].' - '.$b[1].'<br>';
}
while($b = $db->fetchrow($r2)) {
echo $b[0].' - '.$b[1].'<br>';
}
?>
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=6421&edit=2
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
