[San-Diego-pm] Stuck again

[Joel Fentin]

I don't know. I don't know how to know.

showmodules.pl says:

DBD::ADO -- 2.99
DBD::CSV -- 0.48
DBD::ODBC -- 1.52
DBD::Oracle -- 1.74
DBD::Pg -- 3.5.3
DBD::SQLite -- 1.50
DBD::mysql -- 4.041
DBI -- 1.636

==============================

On 12/19/2016 10:36 AM, Mark Schoonover wrote:
> Do you have the correct DBD installed?
>
>
> Mark Schoonover KA6WKE
> Author: 4NEC2 The Definitive Guide
> <https://leanpub.com/4nec2definitiveguide>
> Website: http://www.ka6wke.net
> Resume: http://cv.ka6wke.net
>
> On Mon, Dec 19, 2016 at 10:29 AM, Joel Fentin <joel at fentin.com
> <mailto:joel at fentin.com>> wrote:
>
>     I'm trying to modify Perl code I wrote years ago. First I have to
>     get it running as is. It won't.
>
>     ---------------
>
>     my $ref=$dbh->selectall_arrayref("SELECT * FROM titulo LIMIT 10");
>
>     There is no error and no data.
>
>     This works on a website on BlueHost.
>     It also works on a personal server in an old computer using old
>     windows, old Perl, old Apache, & old MySQL.
>
>     ---------------
>
>     So then, I tried something newer:
>
>     $sth = $dbh->prepare("SELECT * FROM titulo LIMIT 10");
>     $sth->execute()||($error="Error:$DBI::errstr\n");
>     $ref=$dbh->fetchall_arrayref();
>     The error: Can't locate object method "fetchall_arrayref" via
>     package "DBI::db" at C:/Apache2.2/cgi-bin/PacoWeb/CDsearch.pl line 285
>
>     (There is a use DBI; statement at the start of the program.)
>
>     Any help/ideas/wisdom/suggestions appreciated.
>
>     --
>     Joel Fentin       tel: 760-749-8863 <tel:760-749-8863>
>     Personal Website: http://fentin.com
>     _______________________________________________
>     San-Diego-pm mailing list
>     San-Diego-pm at pm.org <mailto:San-Diego-pm at pm.org>
>     http://mail.pm.org/mailman/listinfo/san-diego-pm
>     <http://mail.pm.org/mailman/listinfo/san-diego-pm>
>
>

-- 
Joel Fentin       tel: 760-749-8863
Personal Website: http://fentin.com