On Fri, 24 May 2002 10:22:54 -0700 Seb <[EMAIL PROTECTED]> wrote: > On Fri, 24 May 2002 10:29:14 +0100 Rory Campbell-Lange > <[EMAIL PROTECTED]> spoke gently: > > can I make the database connection on new() and keep reusing it until > > $d is destroyed? > > Along the same vein... > Out of curiosity, are there any potential problems with simultaneous > statements on the same db handle? Say while the program is fetching from > one statement handle it prepares and executes another statement using > the same dbh. Is that sound, or should the program get a second db > handle for it?
As others said, it depends on your database backend. For example for Sybase You cannot use two different statements as long as AutoCommit is off. Waldemar -- o Powiadam Wam, iż straszny czas nastał na ulicach po owym pamiętnym zaćmieniu Słońca. Albowiem wtedy właśnie uzyskałem prawo jazdy.
