Re: [fw-general] PDO problems

2007-02-12 Thread Bill Karwin
Right, currently all queries in Zend_Db are prepared with the PDO::prepare() method (if you use one of the PDO adapters). As far as I know, this issue cannot be fixed in the Zend Framework. It would have to be fixed in PDO. A workaround exists: you can gain access to the PDO connection and th

Re: [fw-general] PDO problems

2007-02-09 Thread Bill Karwin
Okay, I think I know what is happening now. Zend_Db does a PDO->prepare() call on the string you send. The strings ':pdo' and ':xe' are recognized by PDO as named parameter placeholders. The MySQL PDO driver substitutes the '?' character because that is what MySQL understands. This is inte

Re: [fw-general] PDO problems

2007-02-08 Thread Bill Karwin
Tautvydas Andrikys wrote: Noticed this while doing query with Zend_Db_Adapter_Pdo_Mysql::fetchOne(...). After digging deeper into code I've found out that there is something wrong with PDO query execution. PDO somehow strangely executes this query: SELECT 'break:pdo \ xe:xe' Your code samples