Re: [R] write.csv +RMySQL request

2008-02-29 Thread Tristan Casey
(y) > close(y)> zzz X x1 >x2 x3 x41 1 1 4 5 72 2 2 3 6 7 > CC: r-help@r-project.org> From: [EMAIL PROTECTED]> Subject: Re: [R] write.csv > +RMySQL request> Date: Fri, 29 Feb 2008 10:50:34 -0500> To: [EMAIL > PROTECTED]> > The following worked for

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Tristan Casey
"","x1","x2","x3","x4","1",1,4,5,7,"2",2,3,6,7> However once again, when I try to capture this output using textConnection, the resulting variable is transformed to the one above. Kind Regards, Tristan Casey BPsySci (UQ)+

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Jeffrey Horner
file.remove(tfile) rm(list=c('tfile','con','Siris','DBiris')) Best, Jeff > >> Date: Fri, 29 Feb 2008 09:16:11 + >> From: [EMAIL PROTECTED] >> To: [EMAIL PROTECTED] >> CC: [EMAIL PROTECTED]; r-help@r-project.org >> Subj

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Charilaos Skiadas
ike a > textConnection? > > >> Date: Fri, 29 Feb 2008 09:16:11 +0000 >> From: [EMAIL PROTECTED] >> To: [EMAIL PROTECTED] >> CC: [EMAIL PROTECTED]; r-help@r-project.org >> Subject: RE: [R] write.csv +RMySQL request >> >> On Fri, 29 Feb 2008, Tristan Casey

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Tristan Casey
efine b as something else, like a textConnection? > Date: Fri, 29 Feb 2008 09:16:11 + > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED]; r-help@r-project.org > Subject: RE: [R] write.csv +RMySQL request > > On Fri, 29 Feb 2008, Tristan Casey wro

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Prof Brian Ripley
se (dbConnect) then pastes the MySQL query? I am unsure how to > specify where the data is going with the file/connection argument. > > Thanks > > >> Date: Fri, 29 Feb 2008 08:44:58 + >> From: [EMAIL PROTECTED] >> To: [EMAIL PROTECTED] >> CC: [EMAIL PROTEC

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Tristan Casey
: Fri, 29 Feb 2008 08:44:58 + > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED]; r-help@r-project.org > Subject: RE: [R] write.csv +RMySQL request > > On Fri, 29 Feb 2008, Tristan Casey wrote: > > > Thanks again for your help. > > >

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Tristan Casey
(UQ) + 4 Festa Court, Capalaba, QLD 4157 H 8/33 Lilly St, Greenslopes, QLD 4120 0450 033 948 > Date: Fri, 29 Feb 2008 05:12:04 + > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED]; r-help@r-project.org > Subject: Re: [R] write.csv +RMySQL request > &g

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Prof Brian Ripley
s, QLD 4120 > 0450 033 948 > > > >> Date: Fri, 29 Feb 2008 05:12:04 + >> From: [EMAIL PROTECTED] >> To: [EMAIL PROTECTED] >> CC: [EMAIL PROTECTED]; r-help@r-project.org >> Subject: Re: [R] write.csv +RMySQL request >> >> On Thu, 28 Feb

Re: [R] write.csv +RMySQL request

2008-02-28 Thread Prof Brian Ripley
On Thu, 28 Feb 2008, jim holtman wrote: > ?capture.output > > myoutput <- capture.output(write.csv(...)) It would be better to write directly to a text connection: see the 'file' argument to write.csv. > On Thu, Feb 28, 2008 at 7:34 PM, Tristan Casey <[EMAIL PROTECTED]> wrote: >> Hello, >> >> I

Re: [R] write.csv +RMySQL request

2008-02-28 Thread jim holtman
?capture.output myoutput <- capture.output(write.csv(...)) On Thu, Feb 28, 2008 at 7:34 PM, Tristan Casey <[EMAIL PROTECTED]> wrote: > Hello, > > I am relatively new to R and learning its ins and outs. As part of a website > I am building, I need to read and write csv files directly from an SQL

[R] write.csv +RMySQL request

2008-02-28 Thread Tristan Casey
Hello, I am relatively new to R and learning its ins and outs. As part of a website I am building, I need to read and write csv files directly from an SQL database. Basically I want to convert R variables (dataframes) into CSV format, store them as another R variable (as a properly formatted te