Re: DBD::mysql and mysql_use_result
Tim Bunce <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl,gmane.comp.lang.perl.modules.dbi.general |
|---|---|
| Message-ID | <[email protected]> |
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. -- MySQL Perl Mailing List For list archives: http://lists.mysql.com/perl To unsubscribe: http://lists.mysql.com/[email protected]