RE: Breaking Up A Date.

2006-02-06 Thread Jonathan Dudson
If it ever gets that bad - I'll send it your way...you can judge for yourself. -Original Message- From: Anthony R. Nemmer [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 8:47 PM To: $Bill Luebkert Cc: [EMAIL PROTECTED]; activeperl@listserv.ActiveState.com Subject: Re: Breaking U

Re: Breaking Up A Date.

2006-02-06 Thread Anthony R. Nemmer
Depends on how good looking the date is too. $Bill Luebkert wrote: Jonathan Dudson wrote: I am pretty much a newbie when it comes to perl. I am trying to break up either localtime or time so they I end up with three separate variables $date (06) $month(02) $year(2006) that I can use in an

Re: Breaking Up A Date.

2006-02-06 Thread $Bill Luebkert
Jonathan Dudson wrote: > I am pretty much a newbie when it comes to perl. > > I am trying to break up either localtime or time so they I end up with > three separate variables $date (06) $month(02) $year(2006) that I can > use in an archiving script. > > Someone suggested using date calc but t

Breaking Up A Date.

2006-02-06 Thread Jonathan Dudson
I am pretty much a newbie when it comes to perl.   I am trying to break up either localtime or time so they I end up with three separate variables $date (06) $month(02)  $year(2006)  that I can use in an archiving script. Someone suggested using date calc but that appears to work with va

Re: Spreadsheet::WriteExcel

2006-02-06 Thread Lynn. Rickards
Ken Barker wrote: I have quite an extensive script that reads a directory and inserts various csv files into an appropriate workbook. All seems to work fine when viewing under Excel 2000. However when the same spreadsheet is opened via Excel 2003 - Excel complains that it appears all numbers

RE: Spreadsheet::WriteExcel

2006-02-06 Thread Ken Barker
Title: Re: Spreadsheet::WriteExcel Highly possible - these csv files are a mess.  Thanks for the tip - I will strip spaces and retry.   Ken     Ken Barker IT Lead Tel: 314-213-7927 1100 Corporate Square St. Louis, MO 63132 [EMAIL PROTECTED] From: Lynn. Rickards [mailto:[EMAIL PROTECTED]

Re: Flocking a DBM files

2006-02-06 Thread David Nicol
i used to always open a separate file explicitly for locking, and flock that file, instead of fooling around with db internals. DBM, in particular, opens two files. Which one, if either, does tie() return? What if you switch to a database that does not use a fh as the tie object? By explicitly c

Spreadsheet::WriteExcel

2006-02-06 Thread Ken Barker
I have quite an extensive script that reads a directory and inserts various csv files into an appropriate workbook.  All seems to work fine when viewing under Excel 2000.  However when the same spreadsheet is opened via Excel 2003 - Excel complains that it appears all numbers are formatted as

Flocking a DBM files

2006-02-06 Thread DZ-Jay
Hello: I've been using for a while the locking mechanism for DBM files described in the Perl Cookbook, recipe 14.5, basically, locking the filehandle returned by tie: $db = tie() $fd = $db-fd; open(DB_FH, "+<&=$fd") or die(...); flock(DB_FH); ... But I have rea

Re: Small and fast db-connection?

2006-02-06 Thread David Burdon
sqlite maybe?http://www.sqlite.org/http://search.cpan.org/~msergeant/DBD-SQLite-1.11/lib/DBD/SQLite.pm Simple an fast.On 06/02/06, Jonny Snell <[EMAIL PROTECTED]> wrote: Hi all!I have a webb application written in perl and using ordinary DBI/DBMmodules to connect to a MySQL database.However, I woul

Small and fast db-connection?

2006-02-06 Thread Jonny Snell
Hi all! I have a webb application written in perl and using ordinary DBI/DBM modules to connect to a MySQL database. However, I would like as small and fast connection as possible using minimum of computer resources. I only need to SELECT from the database in this application. Is there any scr