I saw this and thought I'd fire off a couple of answers to questions that have stumped me in the past. Hopefully if more people can post tips then the FAQ can be better for everyone. Here's my contribution here in case it's handy.

Why does selectall_hashref now fail (changed in 1.20):
change $hr = $dbh->selectall_hashref($sql, {}, @bind) to $hr = $dbh->selectall_arrayref($sql, {Slice=>{}}, @bind)

Why does getting values from the CGI.pm param function not work as expected when I insert them into the database?
CGI.pm returns an empty parameter as an empty string '' so you need to make sure you undef them first!

How do I use a DSN-less connection with DBD::ODBC?
Look up the exact name of the driver in ODBC manager for example for Access it is "Access Driver (*.mdb)" and use this string as the DSN:
$dsn = "driver=$driver;dbq=$path_to_db"; $dbh = DBI->connect("dbi:ODBC:$dsn");

gav^

In reply to Re: dbi faq updates by gav^
in thread dbi faq updates by ralphie

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.