in reply to Database connection issue

SELECT * FROM Games

As an aside, * is best not used outside of COUNT(), EXISTS(), and ad-hoc queries. A column list would self-document the code, and prevent any issues that may arise from column changes, such as adding, deleting, or reordering.

Replies are listed 'Best First'.
Re^2: Database connection issue
by LanX (Saint) on Nov 15, 2015 at 02:48 UTC
    > prevent any issues that may arise from column changes, such as adding, deleting, or reordering

    well using DBI->fetchrow_hashref should solve this, except maybe by not rasing an instant error for deleted columns (but the code would need to be rewritten in that case anyway.)

    Cheers Rolf
    (addicted to the Perl Programming Language and ☆☆☆☆ :)
    Je suis Charlie!