[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