Bug #6421 Updated: PEAR - error emulating prepare/execute with PostgreSQL

ID: 6421 Updated by: sbergmann Reported By: heino@bigfoot.com 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] heino@bigfoot.com 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