Re: dealing with csv files

2001-03-18 Thread Jeff Zucker 

Stacy Mader wrote:
 
 Hi all,
 
 In a file called weather (in /tmp/weather_db) I have some date files in
 the following format:
 
 
DateTime,MaxWSpd,AvgWSpd,WindDir,AirPres,RainBkt,RelHumd,OutTemp,InsTemp,MsrTemp,FocTemp,XtrTemp


The column name "DateTime" is not a valid SQL column name.  Column
names can not contain anything other than letters, numbers, and
underscores.

-- 
Jeff

Re: dealing with csv files

2001-03-18 Thread Stacy Mader 


Even if I rename DateTime to DateTime, my perl code does not
return any columns!

Regards,

Stacy.


On 18 Mar
2001, Jeff Zucker wrote:

 Stacy Mader wrote:
 
  Hi all,
 
  In a file called weather (in /tmp/weather_db) I have some date files in
  the following format:
 
  
DateTime,MaxWSpd,AvgWSpd,WindDir,AirPres,RainBkt,RelHumd,OutTemp,InsTemp,MsrTemp,FocTemp,XtrTemp


 The column name "DateTime" is not a valid SQL column name.  Column
 names can not contain anything other than letters, numbers, and
 underscores.

 --
 Jeff

Re: dealing with csv files

2001-03-17 Thread Warren Pollans 

I cut and pasted the two data lines into one file and the script into
another and got the same result as Stacy - no output - similar
report.log.

perl 5.6.0 and current verions (as of a month ago) of DBD::CSV and DBI

Warren


Ron Savage wrote:
 
 Stacy
 
 Your code works for me.
 
 Cheers
 Ron  Savage
 [EMAIL PROTECTED]
 http://savage.net.au/index.html

Re: dealing with csv files

2001-03-17 Thread Stacy Mader 


Hmmm, curious. Ron, what version of DBD::CSV are you using? I'm
using 1.14 with perl5.6.0

Regards,
Stacy.


Warren Pollans wrote:

 I cut and pasted the two data lines into one file and the script into
 another and got the same result as Stacy - no output - similar
 report.log.

 perl 5.6.0 and current verions (as of a month ago) of DBD::CSV and DBI

 Warren

 Ron Savage wrote:
 
  Stacy
 
  Your code works for me.
 
  Cheers
  Ron  Savage
  [EMAIL PROTECTED]
  http://savage.net.au/index.html