Date sent: 12 Jul 2001 10:19:48 -0700
From: "Jeff Zucker" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Organization: -
Subject: Re: .htpasswd and DBD::CSV
> Orlando Andico wrote:
> >
> >
> > in my experience DBD::CSV can be iffy. I just use Text::CSV_XS (where you
> > can better control delimiters and stuff)
>
> Sorry, but AFAIK that just ain't true. DBD::CSV *uses* Text::CSV_XS and
> anything you can set directly in Text_CSV_XS you can set through
> DBD::CSV including the field and record separators and escape
> characters. Whether DBD::CSV tells your settings to Text::CSV_XS or you
> tell them to Text::CSV_XS yourself is fairly irrelevant.
regarding the items you mentioned above, true. But *DBD::CSV does not work
with files containing periods the file name*, because the file names are used
as the table names by the SQL Layer on top of Text::CSV_XS. For this reason
DBD::CSV does not work with files like .htaccess. You will either have to
rename them or use a workaround given in the DBD::CSV pod, which I cite below
(but have never tried yet).
These are merely restrictions of the DBD::File or SQL::Statement modules:
...
Table name mapping
Currently it is not possible to use files with names like names.csv. Instead you have
to use soft links
or rename files. As an alternative one might use, for example a dbh attribute
'table_map'. It might be
a hash ref, the keys being the table names and the values being the file names.
Bodo
[EMAIL PROTECTED]
