On Sat, 1 May 2004 18:53:30 +0100, Tim Bunce typed: > > Comments? 1) I was going to do a pod2html on this email and post it someplace so that we don't end up with emails that include the text over and over, but my ASP is down at the moment. You might consider the same.
2) A thought - Someone is going to come out of the woodwork and tell you why ';' won't work as a delimiter. You are going to need to write parsing code to find the ';'. M. Peppler is going to have to rework Sybase to get at the same info as provided by this new functionality 'cause odds are the sql fed to DBD::Sybase is not going to have ;. And there will be a clamoring for more 'per-result' set functionality. Sooooo, I say, if you want multiset functionality, pass in multiple sets. Instead of containing all the sql together with ; in between batches, pass in an array ref of sql statements, each comprising a 'batch'. That way, there is no semicolon parsing required on DBI's part, Peppler can write code to process this stuff in the new way, but if I pass one big SQL statement, it behaves as is, with no access to the enhanced data available and eventually, if there is per-batch-set functionality to be made available, you can replace each sql statement in the array with a DBI::BatchStatement object to provide and interface to each result. Sorry this is so rushed, but I have a family engagement to go to NOW, but I wanted to get the idea out there before the conversation got too involved. -- Matthew O. Persico
