[EMAIL PROTECTED] writes:
$dbh-{csv_tables}-{htp}-{file} = '.htpasswd';
tnx jeff. it's working. now i can open .htpasswd using DBD::CSV
Bodo Eing wrote:
regarding the items you mentioned above, true. But *DBD::CSV does not work
with files containing periods the file name*,
Not quite right, see below.
because the file names are used
as the table names by the SQL Layer on top of Text::CSV_XS.
Right, because a period in a
and DBD::CSV
[EMAIL PROTECTED] writes:
Yeah well, to open an .htpasswd you just use split..
open (HT, .htpasswd) or die;
while (chomp ($line = HT)) {
@flds = split (/:/, $line);
# do your DBI stuff
}
this is easy!! what's the problem?
i thought it's like DBD::CSV where i can connect
Perl DBI wrote:
i thought it's like DBD::CSV where i can connect to a CSV file and use
SQL. how about DBD::RAM?
Actually DBD::RAM has been replaced by DBD::AnyData, and both of them
will do what you want -- allow you to run SQL on a .htpasswd file.
Here's how:
use DBI;
my $dbh =
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
how can i connect to .htpasswd using DBD::CSV? particularly those file
with period (.) at the beginning.
this is the error im getting.
DBD::CSV::db prepare failed: Parse error near .prog where
progname='Prepaid Domains' at /usr/lib/perl5/site_pe
rl/5.005/DBD/File.pm line 164.
Can't call
yes. i already tried it.
[EMAIL PROTECTED] writes:
I could be wrong but have you tried \.prog instead.
adrian
-Original Message-
From: Perl DBI [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 12 July 2001 16:09
To: [EMAIL PROTECTED]
Subject: .htpasswd and DBD::CSV
how can i connect
On Thu, 12 Jul 2001, Perl DBI wrote:
..
yes. i already tried it.
in my experience DBD::CSV can be iffy. I just use Text::CSV_XS (where you
can better control delimiters and stuff) and DBD::RAM. =)
--
Orlando Andico [EMAIL PROTECTED]
Mosaic Communications, Inc.
-BEGIN GEEK CODE
[EMAIL PROTECTED] writes:
On Thu, 12 Jul 2001, Perl DBI wrote:
..
yes. i already tried it.
in my experience DBD::CSV can be iffy. I just use Text::CSV_XS (where you
can better control delimiters and stuff) and DBD::RAM. =)
which one can open a .htpasswd? and easy to use?
and DBD::CSV
[EMAIL PROTECTED] writes:
On Thu, 12 Jul 2001, Perl DBI wrote:
..
yes. i already tried it.
in my experience DBD::CSV can be iffy. I just use Text::CSV_XS (where you
can better control delimiters and stuff) and DBD::RAM. =)
which one can open a .htpasswd? and easy to use?
10 matches
Mail list logo