[San-Diego-pm] Stuck again

Joel Fentin joel at fentin.com
Mon Dec 19 13:49:53 PST 2016


Thank you for getting back to me.

I made the change. No error. No data.

In the old computer where all works:
DBD::SQLite -- 1.13
DBD::mysql -- 3.0002
DBI -- 1.58

Can it be that selectall_arrayref & fetchall_arrayref have been dropped?

In another program within the computer fetchrow_array works.

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

On 12/19/2016 11:47 AM, Tim Bollman wrote:
> 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
> <mailto:joel at fentin.com>> wrote:
>
>     I don't know. I don't know how to know.
>
>     showmodules.pl <http://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
>         <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>
>         <mailto: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>
>         <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>
>         <mailto: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>
>             <http://mail.pm.org/mailman/listinfo/san-diego-pm
>         <http://mail.pm.org/mailman/listinfo/san-diego-pm>>
>
>
>
>     --
>     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


More information about the San-Diego-pm mailing list