fetch( ) without execute( ) Error...

[NIPP, SCOTT V (SBCSI)]

        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