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
