Re: Very slow executes with utf8 integer parameters in DBD::Oracle

2007-09-17 Thread Peter J. Holzer
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

Re: Very slow executes with utf8 integer parameters in DBD::Oracle

2007-09-17 Thread Martin Evans
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

2nd Patch for SQL::Statement

2007-09-17 Thread jens . rehsack
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

Re: Question that may not have an answer

2007-09-17 Thread Alex Teslik
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 mysql

Question that may not have an answer

2007-09-17 Thread Scott Mohnkern
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

Re: Question that may not have an answer

2007-09-17 Thread Bill Kurland
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

RE: Question that may not have an answer

2007-09-17 Thread Fong, Anna
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

Re: Question that may not have an answer

2007-09-17 Thread Ron Savage
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

Problem with selecting rows from a database link

2007-09-17 Thread Crosbourne, Rainaldo
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',{

Looking for a good explanation of select function in perl dbi

2007-09-17 Thread Scott Mohnkern
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=given value This works from the