With the version of MySQL I'm using (5.0.24), if the stored procedure
returns even 1 result set, then it is necessary to flush the list
with mysql_next_result(). Otherwise, the connection becomes unusable
for subsequent queries.
--
kobi
On Dec 22, 2006, at 5:45 AM, Dan Pascu wrote:
On Friday 22 December 2006 10:47, Kobi Eshun wrote:
By the way, I found out by accident that if a stored procedure does
not return any result set, that the existing API works just fine (at
least so far).
Without any changes (except the CLIENT_MULTI_RESULTS flag), the
current
implementation works just fine as long as the stored procedure
returns 0
or at most 1 result sets. The trouble starts with more than 1
result set.
--
Dan
_______________________________________________
Devel mailing list
Devel@openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel
