I don't think you should be calling finish before fetching. I think
that is the problem here.
Michael
> Date: Wed, 3 Sep 2003 12:01:03 -0500
> From: "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: RE: fetch( ) without execute( ) Error...
>
> OK. The other execute is further up. I am actually receiving this
> error for each fetchrow_hashref. Here is a bit more of the code:
>
> my $test2 = $dbh2->prepare("SELECT id FROM fsref WHERE server ='$server'
> AND f
> s_name = '$fs_name'");
> $test2->execute();
>
> $rows2 = $test2->rows();
> print "Number of matching rows: $rows2 \n";
> $test2->finish();
> if ($rows2 == 1) {
> my $vals = $test2->fetchrow_hashref ('NAME_lc');
> my $id = $vals->{id};
> my $query = $dbh2->prepare("SELECT * FROM fsdata WHERE id ='$id'");
> $query->execute();
> $query->finish();
> while (my $ref2 = $query->fetchrow_hashref ('NAME_lc')) {
> undef $set2;
>
> This now includes the other execute. Thanks again.
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, September 03, 2003 11:54 AM
> To: NIPP, SCOTT V (SBCSI)
> Cc: [EMAIL PROTECTED]
> Subject: Re: fetch( ) without execute( ) Error...
>
>
>
> Which fetchrow_hashref line? I see two of them, but only one execute. You
> need to include more code for anyone to know what's really wrong here.
>
>
> ____________________________
> Jeff Seger
> Fairchild Semiconductor
> [EMAIL PROTECTED]
> ____________________________
>
>
>
>
> "NIPP, SCOTT V (SBCSI)" <[EMAIL PROTECTED]>
>
>
> 09/03/2003 12:43 PM
>
>
>
> To: [EMAIL PROTECTED]
> cc:
> Subject: fetch( ) without execute( ) Error...
>
>
>
> I keep coming up with this error, but I AM performing an
> execute
> prior to the fetch. I have seen some other threads on this, and have
> upgraded the DBD:Mysql to the latest version on CPAN. Any ideas? Here is a
> small portion of the code:
>
> if ($rows2 == 1) {
> my $vals = $test2->fetchrow_hashref ('NAME_lc');
> my $id = $vals->{id};
> my $query = $dbh2->prepare("SELECT * FROM fsdata WHERE id ='$id'");
> $query->execute();
> $query->finish();
> while (my $ref2 = $query->fetchrow_hashref ('NAME_lc')) {
> undef $set2;
>
> I am getting an error on the fetchrow_hashref line. Thanks
> in
> advance.
>
> Scott Nipp
> Phone: (214) 858-1289
> E-mail: [EMAIL PROTECTED]
> Web: http:\\ldsa.sbcld.sbc.com
>
>
>
>
>
>
>
>
---//---
I don't need to compromise my principles, because they don't have the
slightest bearing on what happens to me anyway.
---Calvin (Calvin & Hobbes).
A computer lets you make more mistakes faster than any invention in human
history - with the possible exceptions of handguns and tequila.
----Ratliffe, M.
