I believe the multi_query method helps freeing results, I dont see
anything in the code about freeing results apart from close, Im not
sure why its trying to be prepared when calling query directly. Has
Zend_Db been tested with multiple stored procedure calls ?
On 12/11/2007, at 7:35 PM, Dan Rossi wrote:
I just tried using mysqli and plain direct queries to stored
procedures, its trying to call _prepare internally and get this
Commands out of sync; you can't run this command now.
I cant seem to free the result after each query.
On 12/11/2007, at 5:50 PM, Dan Rossi wrote:
["driver_options"]=> array(1) { [1000]=> int(1) }
$this->_config['driver_options'] =
array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true);
Even fudging the option inside the class doesnt work.
The suggested
PDO::setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, true);
Breaks the connection.
How do i free the results so i can call multiple stored procedure
queries ? This is bizarre, I'm doubting its a zend bug, im
definitely sending the driver option.
On 12/11/2007, at 4:12 PM, Dan Rossi wrote:
I'll recompile PHP before filing a bug report I guess ? Its really
bizarre, its happening on the FreeBSD machine with the latest
mysql 5 port but not on my local machine.
Even setAttribute doesnt work.
On 12/11/2007, at 4:04 PM, Dan Rossi wrote:
The array becomes
array(2) { ["adapter"]=> string(9) "Pdo_Mysql" ["params"]=>
array(6) { ["host"]=> string(9) "localhost" ["username"]=>
string(11) "" ["password"]=> string(13) "" ["dbname"]=>
string(12) "s" ["profiler"]=> array(1) { ["enabled"]=> string(4)
"true" } ["driver_options"]=> array(1) { [1000]=> bool(true) } } }
Its still happening !
