[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