From: dimas at webimpact dot com
Operating system: Linux wiaspweb17 2.6.9-34.ELsmp
PHP version: 5.2.9
PHP Bug Type: PDO related
Bug description: PDO statement blank page
Description:
------------
Good day,
we are using PDO and got into the funny problem,
The code below shows that we are trying to simple reuse the statement
but when first query with ci_id = 700000 brings not result, PDO dies
on a second execute. We see only blank page, if first query brings
some results everything is fine.
Can u please help.
Thank you.
Reproduce code:
---------------
$oDbConn = new PDO("dblib:dbname=;host=:1433", "" , "");
$oDbConn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$oStatement = $oDbConn->prepare('SIMPLE SELECT QUERY WHERE ci_id =
:ci_id');
$oStatement->bindParam(':ci_id', $val, PDO::PARAM_INT);
$val = 700000;
$oStatement->execute();
$val = 1000;
$oStatement->execute();
--
Edit bug report at http://bugs.php.net/?id=47764&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=47764&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=47764&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=47764&r=trysnapshot60
Fixed in CVS:
http://bugs.php.net/fix.php?id=47764&r=fixedcvs
Fixed in CVS and need be documented:
http://bugs.php.net/fix.php?id=47764&r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=47764&r=alreadyfixed
Need backtrace:
http://bugs.php.net/fix.php?id=47764&r=needtrace
Need Reproduce Script:
http://bugs.php.net/fix.php?id=47764&r=needscript
Try newer version:
http://bugs.php.net/fix.php?id=47764&r=oldversion
Not developer issue:
http://bugs.php.net/fix.php?id=47764&r=support
Expected behavior:
http://bugs.php.net/fix.php?id=47764&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=47764&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=47764&r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=47764&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=47764&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=47764&r=dst
IIS Stability:
http://bugs.php.net/fix.php?id=47764&r=isapi
Install GNU Sed:
http://bugs.php.net/fix.php?id=47764&r=gnused
Floating point limitations:
http://bugs.php.net/fix.php?id=47764&r=float
No Zend Extensions:
http://bugs.php.net/fix.php?id=47764&r=nozend
MySQL Configuration Error:
http://bugs.php.net/fix.php?id=47764&r=mysqlcfg
