<div dir="ltr">I believe your problem is simply that you want $sth->fetchall_arrayref() instead of $dbh->...;<div><br></div><div>-Tim</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Dec 19, 2016 at 11:29 AM, Joel Fentin <span dir="ltr"><<a href="mailto:joel@fentin.com" target="_blank">joel@fentin.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I don't know. I don't know how to know.<br>
<br>
<a href="http://showmodules.pl" rel="noreferrer" target="_blank">showmodules.pl</a> says:<br>
<br>
DBD::ADO -- 2.99<br>
DBD::CSV -- 0.48<br>
DBD::ODBC -- 1.52<br>
DBD::Oracle -- 1.74<br>
DBD::Pg -- 3.5.3<br>
DBD::SQLite -- 1.50<br>
DBD::mysql -- 4.041<br>
DBI -- 1.636<br>
<br>
==============================<span class=""><br>
<br>
On 12/19/2016 10:36 AM, Mark Schoonover wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
Do you have the correct DBD installed?<br>
<br>
<br>
Mark Schoonover KA6WKE<br>
Author: 4NEC2 The Definitive Guide<br></span>
<<a href="https://leanpub.com/4nec2definitiveguide" rel="noreferrer" target="_blank">https://leanpub.com/4nec2defi<wbr>nitiveguide</a>><span class=""><br>
Website: <a href="http://www.ka6wke.net" rel="noreferrer" target="_blank">http://www.ka6wke.net</a><br>
Resume: <a href="http://cv.ka6wke.net" rel="noreferrer" target="_blank">http://cv.ka6wke.net</a><br>
<br>
On Mon, Dec 19, 2016 at 10:29 AM, Joel Fentin <<a href="mailto:joel@fentin.com" target="_blank">joel@fentin.com</a><br></span><span class="">
<mailto:<a href="mailto:joel@fentin.com" target="_blank">joel@fentin.com</a>>> wrote:<br>
<br>
  I'm trying to modify Perl code I wrote years ago. First I have to<br>
  get it running as is. It won't.<br>
<br>
  ---------------<br>
<br>
  my $ref=$dbh->selectall_arrayref(<wbr>"SELECT * FROM titulo LIMIT 10");<br>
<br>
  There is no error and no data.<br>
<br>
  This works on a website on BlueHost.<br>
  It also works on a personal server in an old computer using old<br>
  windows, old Perl, old Apache, & old MySQL.<br>
<br>
  ---------------<br>
<br>
  So then, I tried something newer:<br>
<br>
  $sth = $dbh->prepare("SELECT * FROM titulo LIMIT 10");<br>
  $sth->execute()||($error="Erro<wbr>r:$DBI::errstr\n");<br>
  $ref=$dbh->fetchall_arrayref()<wbr>;<br>
  The error: Can't locate object method "fetchall_arrayref" via<br>
  package "DBI::db" at C:/Apache2.2/cgi-bin/PacoWeb/C<wbr>Dsearch.pl line 285<br>
<br>
  (There is a use DBI; statement at the start of the program.)<br>
<br>
  Any help/ideas/wisdom/suggestions appreciated.<br>
<br>
  --<br></span>
  Joel Fentin    tel: <a href="tel:760-749-8863" value="+17607498863" target="_blank">760-749-8863</a> <tel:<a href="tel:760-749-8863" value="+17607498863" target="_blank">760-749-8863</a>><span class=""><br>
  Personal Website: <a href="http://fentin.com" rel="noreferrer" target="_blank">http://fentin.com</a><br>
  ______________________________<wbr>_________________<br>
  San-Diego-pm mailing list<br></span>
  <a href="mailto:San-Diego-pm@pm.org" target="_blank">San-Diego-pm@pm.org</a> <mailto:<a href="mailto:San-Diego-pm@pm.org" target="_blank">San-Diego-pm@pm.org</a>><br>
  <a href="http://mail.pm.org/mailman/listinfo/san-diego-pm" rel="noreferrer" target="_blank">http://mail.pm.org/mailman/lis<wbr>tinfo/san-diego-pm</a><br>
  <<a href="http://mail.pm.org/mailman/listinfo/san-diego-pm" rel="noreferrer" target="_blank">http://mail.pm.org/mailman/li<wbr>stinfo/san-diego-pm</a>><br>
<br>
<br>
</blockquote><div class="HOEnZb"><div class="h5">
<br>
-- <br>
Joel Fentin    tel: <a href="tel:760-749-8863" value="+17607498863" target="_blank">760-749-8863</a><br>
Personal Website: <a href="http://fentin.com" rel="noreferrer" target="_blank">http://fentin.com</a><br>
______________________________<wbr>_________________<br>
San-Diego-pm mailing list<br>
<a href="mailto:San-Diego-pm@pm.org" target="_blank">San-Diego-pm@pm.org</a><br>
<a href="http://mail.pm.org/mailman/listinfo/san-diego-pm" rel="noreferrer" target="_blank">http://mail.pm.org/mailman/lis<wbr>tinfo/san-diego-pm</a><br>
</div></div></blockquote></div><br></div>