Re: [R] write.csv +RMySQL request

2008-02-29 Thread Tristan Casey
> explains this part.> > x <- character()> > y<-textConnection("x", open="w")> write.csv(iris,file=y)> close(y)> > Haris > Skiadas> Department of Mathematics and Computer Science> Hanover College> > > On Feb 29, 2008,

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 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 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
am aware of the file argument, however that is the problem, storing to a physical text file and then importing into the SQL database is a very inefficient way of doing things, especially when I can use RMySQL to send commands directly to the database. Kind Regards, Tristan Casey BPsySci

[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