Re: Query problem in Perl

2002-09-02 Thread Ralf Narozny
Hello! Almar van Pel wrote: >Hello, > >I was trying to create a simple perl program, where my domains where listed >followed by there DNS records. >But It loops once, and then ends with error DBD::mysql::st fetch failed: >fetch() without execute() at test.cgi line 61. > >I thougt this was the ea

Re: Query problem in Perl

2002-09-02 Thread Martin Waite
On Mon, 2002-09-02 at 11:37, Harald Fuchs wrote: > In article <1030961610.8175.5.camel@pascal>, > Martin Waite <[EMAIL PROTECTED]> writes: > > > Hi, > > You need to use two separate database and statement handles - you can > > only have one active query per handle. > > > eg. > > > $dbh1 = DBI-

Re: Query problem in Perl

2002-09-02 Thread Martin Waite
Hi, You need to use two separate database and statement handles - you can only have one active query per handle. eg. $dbh1 = DBI->connect(...); $dbh2 = DBI->connect(...); $sth1 = $dbh1->prepare( ... ); $sth1->execute(...); while ( $sth1->fetch() ) { $sth2 = $dbh2->prepare( ... );

Query problem in Perl

2002-08-31 Thread Almar van Pel
Hello, I was trying to create a simple perl program, where my domains where listed followed by there DNS records. But It loops once, and then ends with error DBD::mysql::st fetch failed: fetch() without execute() at test.cgi line 61. I thougt this was the easyest way to do so. But no.. Does anyo

Query problem in Perl

2002-08-31 Thread Almar van Pel \(Koekjes.Net\)
Hello, I was trying to create a simple perl program, where my domains where listed followed by there DNS records. But It loops once, and then ends with error DBD::mysql::st fetch failed: fetch() without execute() at test.cgi line 61. I thougt this was the easyest way to do so. But no.. Does anyo