Current script does this in sequence.
connect
pull data based on select
copy/import into PG
wait 30 secs
connect again.
I've turned on connection logging in PG and I noticed that I keep
seeing
LOG : connection received
statuses.
Which means that the script is connecting to the server every 3
Well, I've figured out how to put data into a sqlite database. I can
extract data from the command line, however, for the life of me, I just
can't find any good documentation on using Select.
What I'm trying to do:
SELECT name, size FROM filelist where uid=
This works from the command line:
sq
Hey guys
I am trying to query a table using a database link, using the following
code:
use strict;
use DBI;
my $col_value = 'test';
my $query = 'select col_1,col_2,col_3 from [EMAIL PROTECTED] where
col_1 = ?';
my $dbh = DBI ->connect ('dbi:Oracle:dbs','username','password',{
R
Scott Mohnkern wrote:
Hi Scott
I recall talking to someone about perl having an internal database file
Your Perl should have come with: AnyDBM_File.html
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html
You can keep the data in CSV format and use DBD::CSV to access the data.
http://search.cpan.org/~jzucker/DBD-CSV-0.22/lib/DBD/CSV.pm
Anna Q. Fong, Chief Phone: (916)
574-2632
Flood Operations, Decision Suppo
Scott Mohnkern wrote:
I'm working on a project where we have data stored in arrays that we need to
put into a database. We'd started with CSV (it was easiest), but it's
become unmanagable.
However, I don't want to go through the pain of getting a mysql database or
other database server set up t
I'm working on a project where we have data stored in arrays that we need to
put into a database. We'd started with CSV (it was easiest), but it's
become unmanagable.
However, I don't want to go through the pain of getting a mysql database or
other database server set up to put the data into.
I
On Mon, 17 Sep 2007 16:04:09 -0400, Scott Mohnkern wrote
> I'm working on a project where we have data stored in arrays that we
> need to put into a database. We'd started with CSV (it was easiest),
> but it's become unmanagable.
>
> However, I don't want to go through the pain of getting a mys
Hi Jeff,
because you didn't answer my last reply I think it's better to send the
2nd bug fix (patch includes fixes sent last times, too) again via
dbi-users@ list. When you're short on time, maybe others who are involved,
may take a look on it. Furthermore SQL::Statement and a lot of DBD-Module
Peter J. Holzer wrote:
On 2007-09-14 18:03:15 +0100, Martin Evans wrote:
I have NLS_LANG=AMERICAN_AMERICA.AL32UTF8 as recommended in DBD::Oracle when
using utf8 and I need to as my data is utf8 in Perl.
Grossly simplified my code does:
o select integer_primary_key_field from table
o prepare(s
On 2007-09-14 18:03:15 +0100, Martin Evans wrote:
> I have NLS_LANG=AMERICAN_AMERICA.AL32UTF8 as recommended in DBD::Oracle when
> using utf8 and I need to as my data is utf8 in Perl.
>
> Grossly simplified my code does:
>
> o select integer_primary_key_field from table
> o prepare(select from a
11 matches
Mail list logo
