[San-Diego-pm] Stuck again

Joel Fentin joel at fentin.com
Mon Dec 19 16:54:59 PST 2016


I thank you for your efforts.

At this point I need to teach myself how to use other than 
selectall_arrayref & fetchall_arrayref.

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

On 12/19/2016 3:37 PM, Christopher Grau wrote:
> At this point, I don't know what to tell you. There doesn't appear to be
> enough information to guess what might be going wrong for you.
>
> The count returns a value, so there must be data in the table. But the
> selection apparently returns nothing. Again, I don't see enough to do
> more than make wild guesses.
>
> The ownership of MySQL is inconsequential. The DBI interface is
> completely removed from that and it is highly unlikely that the
> DBD::mysql module would let it vanish, breaking the entire interface.
>
> On Mon, Dec 19, 2016 at 2:48 PM, Joel Fentin <joel at fentin.com
> <mailto:joel at fentin.com>> wrote:
>
>     I have another tool that displays the right data.
>
>     For purposes of this inquiry, I pasted the following in the same
>     place in the program:
>
>     my $QtyDiscos = $dbh->selectrow_array("SELECT COUNT(*) FROM
>     titulo");#qty of CDs in DB
>     die "|$QtyDiscos|";
>
>     The result: |26898|
>
>     MySQL has been bought and sold a few times. I don't know very much,
>     but my hunch is that this is about changes/disappearances/different
>     instructions regarding selectall_arrayref & fetchall_arrayref.
>

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


More information about the San-Diego-pm mailing list