multiple prepare calls

2004-08-25 Thread Registry
Hello, I hope I am addressing this question to a correct email. I am trying to make multiple prepare statements on one database connection, however I am getting errors. I would just like to know if this is possible. The logic goes something like: my $DBH = DBI-connect(); my $sth =

Re: multiple prepare calls

2004-08-25 Thread Joel West
On Wed, 25 Aug 2004, Registry wrote: N. B. my $sth2 = $DBH2 -prepare( SELECT ...); my $rv2 = $sth2-execute(); not $DBH Thank you in advance.

RE: multiple prepare calls

2004-08-25 Thread Jeff Urlwin
Hello, I hope I am addressing this question to a correct email. I am trying to make multiple prepare statements on one database connection, however I am getting errors. I would just like to know if this is possible. The logic goes something like: my $DBH = DBI-connect(); my $sth

Re: multiple prepare calls

2004-08-25 Thread Jenda Krynicky
From: Registry [EMAIL PROTECTED] I hope I am addressing this question to a correct email. I am trying to make multiple prepare statements on one database connection, however I am getting errors. I would just like to know if this is possible. The logic goes something like: my $DBH =

Re: multiple prepare calls

2004-08-25 Thread Hardy Merrill
Original OP - how about some more info? Copy and paste in the errors that you are getting. Hardy Merrill Jenda Krynicky [EMAIL PROTECTED] 08/25/04 01:47PM From: Registry [EMAIL PROTECTED] I hope I am addressing this question to a correct email. I am trying to make multiple prepare

Re: multiple prepare calls

2004-08-25 Thread Michael Peppler
On Wed, 2004-08-25 at 18:35, Registry wrote: Hello, I hope I am addressing this question to a correct email. I am trying to make multiple prepare statements on one database connection, however I am getting errors. As Jeff says - this works with some database servers and DBD drivers, and

Re: multiple prepare calls

2004-08-25 Thread amonotod
From: Michael Peppler [EMAIL PROTECTED] Date: 2004/08/25 Wed PM 05:53:07 GMT Sybase and MS-SQL don't normally support multiple active statements on the same connection, though DBD::Sybase will allow this by opening a second connection under the covers. I can tell you that MS-SQL via