Aparantly this is also possible but only when a connection is made so
after the first query unless db connect is made.
$db->getConnection()-
>setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true);
Exceptions are bubbled up to the error controller.
On 12/11/2007, at 3:23 PM, till wrote:
On Nov 11, 2007 11:09 PM, Dan Rossi <[EMAIL PROTECTED]> wrote:
Ive tried to also add the config to the config object but there is
issues
with it
$config->database->driver_options = array();
$db = Zend_Db::factory($config->database);
Fatal error: Uncaught exception 'Zend_Config_Exception' with message
'Zend_Config is read only' in
Sorry man, but isn't the error obvious? You tried to manipulate your
Zend_Config object but you are not supposed to.
A try/catch block around that should help you out.
On 12/11/2007, at 3:00 PM, Dan Rossi wrote:
Hi there still getting these errors, it doesnt seem that Zend_Db is
actually
calling fetchAll on the PDO library, the result isnt being free'd
so im
getting this error
General error: 2014 Cannot execute queries while other unbuffered
queries
are active. Consider using PDOStatement::fetchAll(). Alternatively,
if your
code is only ever going to run against mysql, you may enable query
buffering
by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
Any ideas ? I cant seem to append this option as i use xml for the
configs.
What does one have to do with the other?
To set pdoparams, Example 10.7:
http://framework.zend.com/manual/en/zend.db.html
Cheers,
Till
