[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sr-dev
Subject:    [Devel] [ openser-Bugs-1618322 ] avp_db_query cannot call mysql
From:       kobi () sightspeed ! com (Kobi Eshun)
Date:       2006-12-22 18:13:49
Message-ID: CD810197-7902-4372-8920-A21C43C97268 () sightspeed ! com
[Download RAW message or body]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://openser.org/pipermail/devel/attachments/20061222/4d25982f/attachment.html

[prev in list] [next in list] [prev in thread] [next in thread]