I am glad that you've solved your problem.

On a side note, I would like to offer some thoughts on your script, if you don't mind.

First of all, the Monastery chant. use strict and warnings, so that you can catch the errors before they catch you.

Then, you are getting a value from standard input without any processing. You should at least use chomp to remove the newline at the end of the string, and then check that your listname doesn't contain any characher that later on may make your life difficult.

Furthermore, a call to $sth->finish is only needed when you are fetching records. For data manipulation commands such as INSERT or UPDATE, you don't need it.

Cheers

In reply to Re: Database access error. by cchampion
in thread Database access error. by devslashneil

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.