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
