RE: [PEAR] Problem using PEAR::DB

> From: patrick.allaert@belgacom.be [mailto:patrick.allaert@belgacom.be] > Sent: Friday, September 26, 2003 4:56 PM > >-----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 ? not sure I fit is feasible to go that route as it means the query needs to be parsed every time. Regards, Lukas