[San-Diego-pm] Stuck again
Tim Bollman
tim.bollman at gmail.com
Mon Dec 19 11:47:20 PST 2016
I believe your problem is simply that you want $sth->fetchall_arrayref()
instead of $dbh->...;
-Tim
On Mon, Dec 19, 2016 at 11:29 AM, Joel Fentin <joel at fentin.com> wrote:
> 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
> _______________________________________________
> San-Diego-pm mailing list
> San-Diego-pm at pm.org
> http://mail.pm.org/mailman/listinfo/san-diego-pm
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.pm.org/pipermail/san-diego-pm/attachments/20161219/46c505b5/attachment-0001.html>
More information about the San-Diego-pm
mailing list