Though we value the time and effort you have taken to answer to this question, I'd advice to read the whole thread before posting next time.

In your elaborate answers, you have left in all the fundamental errors of the OP and only commented on possible improvements on the sequence of coding that do not solve the question at hand, thus adding distraction to the readers however well you meant, this does not help.

Declaring a SQL statement is not the same thing as preparing it. If you have read the book you point to, you should know that :)

The OP has nothing to do with declaring or preparing the SQL statement, but with using the correct syntax in being able to access a table. Quoting might be more an issue here than shuffling the code around.

Personally, I would not put the statement in a variable at all, but pass it directly to the prepare method, but TIMTOWTDI, and neither is wrong.

$sth->finish is only to be executed on non-select handles. The book is a bit outdated/obsoleted in that subject.


Enjoy, Have FUN! H.Merijn

In reply to Re^2: Trouble getting DBD::CSV to work by Tux
in thread Trouble getting DBD::CSV to work by paulski82

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.