apr-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Kew <n...@webthing.com>
Subject Re: apr_dbd: supporting multiple selects + results sets
Date Mon, 14 May 2007 23:23:08 GMT

On 14 May 2007, at 23:49, Matthew Kent wrote:

> On Sun, 2007-13-05 at 18:31 +1000, Ian Holsman wrote:
>> Hi Guys,
>>
>> One of the 'new' features of mysql (in 5.0) is the support of  
>> multiple
>> result sets being returned to the client, and the ability to send
>> multiple statements in 1 shot by setting a flag when you open the
>> connection. Multiple result sets are also required if you intent  
>> to call
>> stored procs.
>>
>> I plan on using it to pipeline SQL requests, and to call stored  
>> procs in
>> mysql.
>>
>> So.. 2 questions.
>>
>> Is this functionality interesting for the APR DBD library in general,
>
> +1 usefulness from me. I'd love this implemented properly.

We seem to have several people interested.  But I'm not clear what  
you're
looking to support over and above what we have.  Anyone care to draft
and propose an API extension for it?

> In case anyone else needs something now here's my quick fix to allow
> calling a MySQL stored procedure without returning an error. It only
> handles the first result set. Against latest apr_dbd_mysql.c

Not sure I like the allow-but-drop-multi-results bit.

-- 
Nick Kew

Mime
View raw message