[pgh-pm] Trying to use DBI:CSV

[James E Keenan]

On Feb 16, 2009, at 3:00 PM, pgh-pm-request at pm.org wrote:

> Message: 1
> Date: Mon, 16 Feb 2009 13:40:50 -0500
> From: Greg Akins
> Subject: [pgh-pm] Trying to use DBI:CSV
>
> First, I'm a perl newbie.. so I'm sorry if I'm asking really stupid  
> questions.
>

This is not a stupid question.  Figuring out how to use DBI is not  
necessarily self-evident.

> I'm trying to use DBI:CSV
>

Unfortunately, I'm not a DBI expert, so I can't answer this off the  
top of my head. :(

> I can create a table so at least part of the packages are installed  
> correctly.
>
> However when I try to insert into it, I get the following message
>
> DBD::CSV::db do failed: Can't locate object method "command" via
> package "DBD::CSV::Statement" at /Library/Perl/5.8.8/DBD/CSV.pm line
> 156.
>  [for Statement "INSERT INTO test_table VALUES (1, 'foobar')"] at
> test.pl line 12.
>
> I'm running perl 5.8.8 on Mac OS 10.5 ; probably not the OS X version
> since 'which perl' shows it's executing from the /usr/bin directory (I
> believe the Mac install is in System)
>

But what I can say is that you are running the perl executable that  
came with your Mac.  The vendor-installed executables are in /usr/ 
bin/.  The libraries that come with "Perl core" are in /usr/lib.  The  
libraries that Apple packages with its perl above and beyond the perl  
core modules are found in /System/Library/Perl/lib/.

Or, at least, so it would appear from my Mac OS 10.4.11; I doubt they  
changed that for 10.5

HTH

Jim Keenan