ID: 47764
User updated by: dimas at webimpact dot com
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:
Good day, yes I cannot reproduce this problem on MySQL, it looks like
its only dblib issue. I noticed it said that extension is experimental.
Is there anything can be done to have it fixed?
Previous Comments:
------------------------------------------------------------------------
[2009-03-25 10:06:03] ka...@php.net
I tried with the PDO_MySQL driver but I can't reproduce the problem,
does this only happen with dblib and on Linux?
------------------------------------------------------------------------
[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] ka...@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
