Still working on publishing my league's hockey stats to the web. Thought things were going well until DBD::CSV started giving me some problems.

I've been developing the site on my Win2k machine, with Apache 1.3.20 and ActiveState Perl 5.6.1.628. I had some of the stats pages done. . . they looked really good and worked well, so I thought I'd move them to my web server (Slackware 8.0, Apache 1.3.23, Perl 5.6.1) for people to admire. The scripts run fine there, but I have no data displayed. The graphics and tables generated come out exactly as intended, but no data is displayed from my CSV files. Even more strange, I'm not getting any errors generated. I've included some code below to give a feel for what I'm doing:

  $sql = $filehandle->prepare($script)
    || die "Couldn't prepare SQL: " . $filehandle->errstr;
  $sql->execute()
    || die "Couldn't prepare SQL: " . $filehandle->errstr;

  while (my $row = $sql->fetchrow_hashref)
  {
    my %row_data;

    $row_data{TEAM} = $row->{'Team'};
    push(@table, \%row_data);
  }

  $sql->finish();

[download]
My connect() call doesn't error out, and I've displayed messages on the web page to show what directory the script was pulling files from to verify they were coming from the right spot (they were). I've even wrote a little script to get the list of tables being used, and all of my CSV files were listed. As a final effort, I made sure that all my unix file permissions were set properly, and again, they were.

What gives? Any clue as to what I'm doing wrong? Any insight is certainly appreciated.

Thanks,
MrCromeDome

In reply to Problems using DBD::CSV by MrCromeDome

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.