Hi thats the error I am getting. using fetchAll instead of query and
fetch worked, but now is stuck on one of them even after calling
fetchAll. I use xml for db configs how am i suppose to pass that flag
to the db factory method ? I believe its some wierd bug with the
mysql library maybe ? I was getting similar issues with results not
being closed properly when calling stored prcoedures aswell as normal
queries using the PEAR MDB2 library and normal mysql functions.
On 10/11/2007, at 7:10 AM, pcalkins wrote:
Hi Daniel,
The SQL error code HYxxx is a general error, I believe this may be
a bug as
I have the same problem as well (a bug report has been created for
this) -
see this earlier post. Is this the same problem you are experiencing?
http://www.nabble.com/Can%27t-execute-multiple-stored-procedures-
with-Pdo_Mysql-tf4687165s16154.html
http://www.nabble.com/Can%27t-execute-multiple-stored-procedures-
with-Pdo_Mysql-tf4687165s16154.html
Thanks-
Patrick Calkins
Daniel Rossi-2 wrote:
Hi there i have an odd problem on our production machine that isnt
showing up locally. How exactly is the best way to call a set of
stored procedures ? I'm getting wierd errors like this
Message: SQLSTATE[HY000]: 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.
Im basically calling query(call procedure) etc.
--
View this message in context: http://www.nabble.com/Issues-with-
stored-procedures-tf4777035s16154.html#a13674126
Sent from the Zend Framework mailing list archive at Nabble.com.
