Have you considered setting up a local PostgreSQL instance? It's pretty easy
to set up these days and can run pretty nicely on a small machine - I have it
on an old laptop for local development. It may be overkill for this particular
case, but you'll likely find it comes in handy down the
; dbi-users@perl.org
Subject: Re: (Fwd) DBI Dilemma
Blake, something you need to clarify is what you are querying against, is it
the SQL database or the .csv file? Either the .csv thing is a red herring or
it sounds like you're using DBD::CSV, so which is it? The solution depends
On 2015-08-18 14:21:39 +, Adkins, Blake wrote:
My script works on the .csv file using dbi:CSV:f_dir and pointing to
different files for different projects.
[...]
I'm using the DBI module in Perl, would this be better with the other modules
mentioned?
[the other module mentioned being
Ron Savage r...@savage.net.au writes:
Hi
$quote = $dbh - get_info(29); # SQL_IDENTIFIER_QUOTE_CHAR.
Even better:
my $quoted_column_name = $dbh-quote_identifier($column_name);
This takes care of escaping any ocurrences of the quote character in the
column name.
--
I use RMS as a guide
Hi
$quote = $dbh - get_info(29); # SQL_IDENTIFIER_QUOTE_CHAR.
--
Ron Savage - savage.net.au
Blake, something you need to clarify is what you are querying against, is it the
SQL database or the .csv file? Either the .csv thing is a red herring or it
sounds like you're using DBD::CSV, so which is it? The solution depends on
this. -- Darren Duncan
On 2015-08-17 2:42 PM,
To: Adkins, Blake; dbi-users@perl.org
Subject: Re: (Fwd) DBI Dilemma
Blake, something you need to clarify is what you are querying against, is it
the SQL database or the .csv file? Either the .csv thing is a red herring or
it sounds like you're using DBD::CSV, so which is it? The solution depends
DBD::CSV, or at least the current version 0.48
http://search.cpan.org/~hmbrand/DBD-CSV-0.48/lib/DBD/CSV.pm uses
SQL::Statement for it’s syntax . See
http://search.cpan.org/~rehsack/SQL-Statement-1.407/lib/SQL/Statement/Syntax.pod#Identifiers_(table__column_names)
This might help you get
On Mon, August 17, 2015 14:42, tim.bu...@pobox.com wrote:
- Forwarded message from Adkins, Blake blake.adk...@intel.com
-
Date: Mon, 17 Aug 2015 17:51:41 +
From: Adkins, Blake blake.adk...@intel.com
To: tim.bu...@pobox.com tim.bu...@pobox.com
Subject: DBI Dilemma
Tim,
- Forwarded message from Adkins, Blake blake.adk...@intel.com -
Date: Mon, 17 Aug 2015 17:51:41 +
From: Adkins, Blake blake.adk...@intel.com
To: tim.bu...@pobox.com tim.bu...@pobox.com
Subject: DBI Dilemma
Tim,
I've been using your module to enable people in my group to do
On Aug 17, 2015, at 2:42 PM, tim.bu...@pobox.com wrote:
- Forwarded message from Adkins, Blake blake.adk...@intel.com -
Date: Mon, 17 Aug 2015 17:51:41 +
From: Adkins, Blake blake.adk...@intel.com
To: tim.bu...@pobox.com tim.bu...@pobox.com
Subject: DBI Dilemma
Tim,
On Mon, Aug 17, 2015 at 5:02 PM, Wm Mussatto mussa...@csz.com wrote:
On Mon, August 17, 2015 14:42, tim.bu...@pobox.com wrote:
- Forwarded message from Adkins, Blake blake.adk...@intel.com
-
Date: Mon, 17 Aug 2015 17:51:41 +
From: Adkins, Blake blake.adk...@intel.com
To:
12 matches
Mail list logo
