From: [EMAIL PROTECTED] Operating system: Win 2K sp 2 PHP version: 4.2.3 PHP Bug Type: OCI8 related Bug description: OCIResult returns gibberish if fetch failed
I have just upgraded from 4.1.2 to 4.2.3. The same code is fine in 4.1.2 but not in 4.2.3. $sql = "SELECT can#id canid FROM cvs WHERE can#id = TO_NUMBER('".$candid."')"; $resultcanid = sql_exec($connectionid, $sql); sql_fetch_row ($resultcanid); echo sql_result($result,"name"); In 4.1.2 if fetch returned nothing then nothing/null is echoed In 4.2.3 the echo produces what looks like buffer info from a previous query. I use same variables for just about all queries ($sql,$result etc) N.B. sql_exec function does a OCIparase followed by a OCIExecute sql_fetch_row does OCIFetch sql_result does OCIResult -- Edit bug report at http://bugs.php.net/?id=19455&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=19455&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=19455&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=19455&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=19455&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=19455&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=19455&r=support Expected behavior: http://bugs.php.net/fix.php?id=19455&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=19455&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=19455&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=19455&r=globals