thanks Neil,
I knew it was something simple, but guess too many hours with other stuff! :)
Thx's
>>On Wed, 8 Aug 2001 12:58:41 +1000 , Neil Lunn <[EMAIL PROTECTED]> wrote:
>>Hmm. Not really a DBI question but I feel charitable. Beside this might stop
>>people asking in the future. See the code below.
>>>-----Original Message-----
>>>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>>>Sent: Wednesday, August 08, 2001 12:50 PM
>>>To: [EMAIL PROTECTED]
>>>Subject: Exporting Data
>>>
>>>
>>>Hello,
>>>
>>>I'm trying come up with a fast and easy way to export all the
>>>data from a table
>>>into a file, tab delimited, but haven't alot of success with this.
>>>
>>>What is the best way to pull all the data from a table, then
>>>put into a text
>>>file and have it tab delimited for each column value:
>>>
>>>$query = qq|select * from orders|;
>>>$sth = $dbh->prepare($query);
>>>$sth->execute();
>>>
>>>open(FILE,">$export_file");
>>>while(my @rows = $sth->fetchrow_array()) {
>>># THIS IS WHERE I SEEM TO LOOSE IT
>>
>>#Instead of this
>>#print FILE @rows . '\t;
>>print FILE join("\t",@rows) ."\n";
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
