#!/fellow/monks.pl

What does this mean? I'm using DBI and DBD-mysqlPP. 

Can't call method "prepare" on an undefined value at mwslib.pl line xx
+x.

[download]

The script works fine on my Redhat 6.2 box, but as soon as I upload my script to my ISP, I get this error in the error_log and the file fails to execute.

Any ideas on why this happens? Here's my procedure.. 

sub mwsexecutesql
{
        local $mwssql = $_[0];
        local $spl = $_[1];
        local $field;
        local $data;
        local @ary;
        $data = "";

        $mwssth = $mwsdbh->prepare(qq{$mwssql}) || &mwserror("DB Error
+: \"" . $mwsdbh->errstr . "\" while preparing SQL statement \"$mwssql
+\"","");
        $mwssth->execute()  || &mwserror("DB Error: " . $mwsdbh->errst
+r . "\" while preparing SQL statement \"$mwssql\"","");

        while (@ary = $mwssth->fetchrow_array())
        {
                foreach $field (@ary)
                {
                        chomp($field);
                        $data =  "$data$field$spl";
                }
                $data = "$data\n";
        }

        $mwssth->finish();
        return substr($data,0,length($data)-1);
}

[download]

Thanks

#!/massyn.pl The more I learn, the more I realize I don't know. Albert Einstein 1879-1955

In reply to Can't call method "prepare" on an undefined value by Massyn

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.