Re: DBD::mysql and mysql_use_result

[Tim Bunce]

On Fri, Aug 13, 2004 at 11:17:51PM +0100, Alan Burlison wrote:
> Tim Bunce wrote:
> 
> >Does the binary protocol allow the link to be used for other actions while
> >there are still rows being sent to the client?
> >
> >If not "use result" can't be the default as too much existing code would 
> >break.
> 
> My experementation would suggest that it doesn't - if you turn 
> use_result on with the existing driver than then try to do a nested 
> prepare/execute/fetch within the outer loop, to get an error - I can't 
> remember the exact wording, but the gist is 'You can't do that now'.

I thought so. Thanks for confirming it. (The standard workaround of using
multiple dbh applies.)

Tim.