#47764 [Opn]: PDO statement blank page
ID: 47764
Updated by: kalle@php.net
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:
I tried with the PDO_MySQL driver but I can't reproduce the problem,
does this only happen with dblib and on Linux?
Previous Comments:
------------------------------------------------------------------------
[2009-03-24 20:05:52] dimas at webimpact dot com
Thanks for a quick reply, that is the problem that absolutely no errors
loged by the server and no exceptions by PDO :-(
------------------------------------------------------------------------
[2009-03-24 19:09:29] kalle@php.net
Does your webserver log show anything that could might have been more
of help here?
------------------------------------------------------------------------
[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
Thread (6 messages)