RE: (Fwd) How to write records from table to csv file?

2001-07-17 Thread De Simone, Andrew (CAP, FGI)
he text fields or if you can control the delimiter on the other side you can use "join" with your own seperator. Andy -Original Message- From: Michael A. Chase [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 9:14 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: (

Re: (Fwd) How to write records from table to csv file?

2001-07-16 Thread Michael A. Chase
The only problem I see is that you are closing the output file as soon as you have fetched and written the first line. You really need to include 'use strict;' near the top of your program and '-w' on the '#!' line. They would help spot problems like that sooner. Including $! in the file open f

RE: (Fwd) How to write records from table to csv file?

2001-07-16 Thread Sterin, Ilya
This is a non DBI related question, but rather a question of how to write out comma delimeted info. See perldoc -f join, then find out why you only have one row, which is probably due to there being only one row to fetch for the query you are running. Ilya -Original Message- From: Tim B