ID: 47764
Updated by: [email protected]
Reported By: dimas at webimpact dot com
Status: Open
Bug Type: PDO related
Operating System: Linux wiaspweb17 2.6.9-34.ELsmp
PHP Version: 5.2.9
New Comment:
Does your webserver log show anything that could might have been more
of help here?
Previous Comments:
------------------------------------------------------------------------
[2009-03-24 18:02:32] dimas at webimpact dot com
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 this bug report at http://bugs.php.net/?id=47764&edit=1