Re: Exporting Data

2001-08-09 Thread Tim Bunce
On Wed, Aug 08, 2001 at 08:20:33PM -0700, Jonathan Leffler wrote: > Tim Bunce wrote: > > > Read the docs and take a look at the dump_results method. > > It's good, but if you insert a string containing single quotes and commas, the output > from dump_results is ambiguous. > > I was messing with

Re: Exporting Data

2001-08-08 Thread Jonathan Leffler
Tim Bunce wrote: > Read the docs and take a look at the dump_results method. It's good, but if you insert a string containing single quotes and commas, the output from dump_results is ambiguous. I was messing with a data string such as: q{ 'How come', he said? } The output from dump_results (

Re: Exporting Data

2001-08-08 Thread Bart Lateur
On Tue, 07 Aug 2001 21:49:47 -0500, [EMAIL PROTECTED] wrote: >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: Well OK. I assume that your fields don't contain tabs nor newlines, and that you thus don't need to qu

Re: Exporting Data

2001-08-08 Thread Scott R. Godin
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] wrote: > print FILE @rows . '\t; why didn't you try print FILE join("\t", @rows), "\n"; ? of course the dump method mentioned in the prev post is a good idea too ;-) -- Scott R. Godin| e-mail : [EMAIL PROTECTED] Laughing Dra

Re: Exporting Data

2001-08-08 Thread Tim Bunce
Read the docs and take a look at the dump_results method. "One call does it all" :-) (Umm, perhaps that should be a DBI slogan.) Tim. On Tue, Aug 07, 2001 at 09:49:47PM -0500, [EMAIL PROTECTED] wrote: > Hello, > > I'm trying come up with a fast and easy way to export all the data from a table

Re: Exporting Data

2001-08-07 Thread mickalo
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 c

RE: Exporting Data

2001-08-07 Thread Neil Lunn
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