(Fwd) RE: [PEAR] Problem using PEAR::DB

Ooops - forgot to include pear-general on my post. Since this is a dev-topic I forwarded it to pear-dev. Stefan ------- Forwarded message follows ------- From: "Stefan Neufeind" <stefan@neufeind.net> To: pear-dev@lists.php.net Date sent: Fri, 26 Sep 2003 17:49:39 +0200 Copies to: <patrick.allaert@belgacom.be> Priority: normal Subject: [PEAR-DEV] RE: [PEAR] Problem using PEAR::DB [ Double-click this line for list subscription options ] On 26 Sep 2003 at 16:56, patrick.allaert@belgacom.be wrote: > >-----Original Message----- > >From: Lukas Smith [mailto:smith@backendmedia.com] > >Sent: 26 September 2003 16:46 > >To: 'Dennis Sterzenbach'; 'ML PEAR General PHP.Net' > >Subject: RE: [PEAR] Problem using PEAR::DB > > > > > >> From: Dennis Sterzenbach [mailto:dennis@darknoise.homeip.net] > >> Sent: Friday, September 26, 2003 4:42 PM > > > >> I've got a problem using PEAR::DB. > >> I'm already used to the PEAR database abstraction layer, > >> but never before I stepped that much into detail of > >> MySQL and PEAR. > >> > >> For me there's obviously no problem putting three queries > >> in one SQL string using phpMyAdmin, neither executing it > >> on shell. > >> But if I try to execute a 'simpleQuery($sql)' with an SQL > >> as follows: > >> $sql = "DELETE FROM logins WHERE uid=8; > >> DELETE FROM users_lists WHERE uid=8; > >> DELETE FROM users WHERE uid=8;" > > > >this is called "batch querying" and it is not supported my mysql > >(frontbase and mssql support it though). > > > >Regards, > >Lukas > > Hi, > > It should be nice having a support for "batch querying" in > PEAR::DB... The DB_common should implement a function splitting the > queries... and the specific DB_* (mysql, oci8, sybase,..) should > call this splitting functions if unable to deal with "batch > queries". > > What do you think about this suggestion ? Yes, I think it's a nice idea. And if you e.g. have a look at phpMyAdmin that's what the guys over there already did / solved in their PHP sources. So it should be possible to use their experience and port that part of source - and not make the same splitting-errors they maybe had in the past again. Such a generic splitting function (maybe returning an array of queries) would be a nice solution. Stefan -- PEAR Development Mailing List (http://pear.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ------- End of forwarded message -------