#47764 [Opn]: PDO statement blank page

2009-03-25 Thread dimas at webimpact dot com
 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 = 70 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 = 70;
$oStatement-execute(); 

$val = 1000;
$oStatement-execute(); 






-- 
Edit this bug report at http://bugs.php.net/?id=47764edit=1



#47764 [NEW]: PDO statement blank page

2009-03-24 Thread dimas at webimpact dot com
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 = 70 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 = 70;
$oStatement-execute(); 

$val = 1000;
$oStatement-execute(); 


-- 
Edit bug report at http://bugs.php.net/?id=47764edit=1
-- 
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=47764r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=47764r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=47764r=trysnapshot60
Fixed in CVS:
http://bugs.php.net/fix.php?id=47764r=fixedcvs
Fixed in CVS and need be documented: 
http://bugs.php.net/fix.php?id=47764r=needdocs
Fixed in release:
http://bugs.php.net/fix.php?id=47764r=alreadyfixed
Need backtrace:  
http://bugs.php.net/fix.php?id=47764r=needtrace
Need Reproduce Script:   
http://bugs.php.net/fix.php?id=47764r=needscript
Try newer version:   
http://bugs.php.net/fix.php?id=47764r=oldversion
Not developer issue: 
http://bugs.php.net/fix.php?id=47764r=support
Expected behavior:   
http://bugs.php.net/fix.php?id=47764r=notwrong
Not enough info: 
http://bugs.php.net/fix.php?id=47764r=notenoughinfo
Submitted twice: 
http://bugs.php.net/fix.php?id=47764r=submittedtwice
register_globals:
http://bugs.php.net/fix.php?id=47764r=globals
PHP 4 support discontinued:  http://bugs.php.net/fix.php?id=47764r=php4
Daylight Savings:http://bugs.php.net/fix.php?id=47764r=dst
IIS Stability:   
http://bugs.php.net/fix.php?id=47764r=isapi
Install GNU Sed: 
http://bugs.php.net/fix.php?id=47764r=gnused
Floating point limitations:  
http://bugs.php.net/fix.php?id=47764r=float
No Zend Extensions:  
http://bugs.php.net/fix.php?id=47764r=nozend
MySQL Configuration Error:   
http://bugs.php.net/fix.php?id=47764r=mysqlcfg



#47764 [Opn]: PDO statement blank page

2009-03-24 Thread dimas at webimpact dot com
 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:

Thanks for a quick reply, that is the problem that absolutely no errors
loged by the server and no exceptions by PDO :-(


Previous Comments:


[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 = 70 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 = 70;
$oStatement-execute(); 

$val = 1000;
$oStatement-execute(); 






-- 
Edit this bug report at http://bugs.php.net/?id=47764edit=1