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
