Re: [R] write.csv +RMySQL request

2008-02-29 Thread Prof Brian Ripley
-project.org Subject: Re: [R] write.csv +RMySQL request 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

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Tristan Casey
, 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 On Thu, 28 Feb 2008, jim holtman wrote

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Tristan Casey
: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. I am wanting my variable to store a character string exactly

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Prof Brian Ripley
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 PROTECTED]; r-help@r-project.org Subject: RE: [R] write.csv +RMySQL request On Fri, 29 Feb 2008, Tristan

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Tristan Casey
, 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 wrote: Ahh, my apologies I must admit that I don't

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Charilaos Skiadas
]; r-help@r-project.org Subject: RE: [R] write.csv +RMySQL request On Fri, 29 Feb 2008, Tristan Casey wrote: Ahh, my apologies I must admit that I don't fully understand textConnections fully. I have been reading up on th RODBC package as an alternative to RMySQL. With the file argument

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Jeffrey Horner
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 PROTECTED]; r-help@r-project.org Subject: RE: [R] write.csv +RMySQL request On Fri

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Tristan Casey
to the one above. Kind Regards, Tristan Casey BPsySci (UQ)+ 4 Festa Court, Capalaba, QLD 4157H 8/33 Lilly St, Greenslopes, QLD 41200450 033 948 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

Re: [R] write.csv +RMySQL request

2008-02-29 Thread Tristan Casey
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 me (put together after reading ? textConnection). Put simply, all read/write command work

[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

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

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 am