fetchall problem

[Maureen E Fischer]

Hello,
I am stuck on a bug in my perl cgi program that uses a mysql database.
In executing the following code I am getting a message in the dump that
the
fetch failed --fetch () without execute ()

would anyone be able to see what I am doing wrong or be able to give me
any
idea of how to go about debugging this.  The execute seemed to go OK and
returned
8 records.

    $sql = "SELECT clientcode FROM clientemployee
        WHERE clientemployee.empid=?";
    $sth = $dbh->prepare($sql);
    $sth->execute("$validemp");
    my $sites = $sth->fetchall_arrayref;
    print DBI::dump_results($sth);
    print "\n\n";

Thanks,
Maureen







-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]