in reply to Re^3: Trouble getting DBD::CSV to work
in thread Trouble getting DBD::CSV to work

DBI-1.609 DBD::CSV-0.22 Text::CSV_XS-0.85 SQL::Statement-1.27 "root".export "root".export3 "root".export2

Replies are listed 'Best First'.
Re^5: Trouble getting DBD::CSV to work
by Tux (Canon) on Aug 05, 2014 at 09:31 UTC

    A lot has changed since DBD-CSV-0.22! That version was from April 2005.

    At the moment of writing, the current versions are:

    DBI-1.631 DBD::CSV-0.44 Text::CSV_XS-1.10 SQL::Statement-1.405

    My first hunch would be, with your old versions, to add the schema:

    my $sth = $dbh->prepare (q{select * from "root".export}); $sth->execute; while (my $h = $dbh->fetchrow_hashref) { # Don't know if casing of fieldnames is sane in those versions # YMMV, $dbh->{FetchHashKeyName} = "NAME_lc"; might help print "ID: ", $h->{id}, ", SN: ", $h->{service_name}; }

    Enjoy, Have FUN! H.Merijn

      I'm running RHEL6, with the packaged PERL. So I rebuilt the latest stable PERL (v5.20.0) from source and installed the latest dependencies.

      DBI-1.631
      DBD::CSV-0.44
      Text::CSV_XS-1.10
      SQL::Statement-1.405

      This seems to have done the trick. It's not ideal, since I have to maintain the source built version. I'll log a bug with Red Hat to see if they can patch it into the next update.

      Thanks for you help

        YEAH! Well done. ++ to your effert.

        Feel free to bug us again when you have other issues.


        Enjoy, Have FUN! H.Merijn