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 in write.csv, are you saying it is possible to > write the csv formated data directly to a cell in a MySQL database? I am > unsure what the variable 'con' must consist of.
No, that it is possible to write it to an R character vector. > Would this need to be a character string that initially connects to the > database (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 +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 wrote: >> >>> Thanks again for your help. >>> >>> I am wanting my variable to store a character string exactly as the >>> write.csv function would store as a csv text file; >>> >>> IE: My goal is to store a data frame of this construction; >>> >>> x1 x2 >>> 1 2 >>> 3 4 >>> >>> as "X1","X2",1,2,3,4 (the same format as CSV). >>> >>> I 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. >> >> You seem however unaware of text connections. Neither of us said anything >> about using a 'physical text file', and the documentation for >> write.csv says >> >> file: either a character string naming a file or a connection open >> for writing. '""' indicates output to the console. >> >> A 'text connection; is not a file (physical or otherwise). >> >> >>> >>> Kind Regards, >>> >>> Tristan Casey BPsySci (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 +0000 >>>> 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: >>>> >>>>> ?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 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 text string suitable for csv reading) and then send this to >>>>>> one row in a database. >>>>>> >>>>>> The SQL part is fine, the problem arises because I cannot capture the >>>>>> output of write.csv! It posts to the terminal when file="" is used, >>>>>> however I also want to store it. Does anyone have any ideas? >>>>>> >>>>>> Thanks in advance! >>>> >>>> -- >>>> Brian D. Ripley, [EMAIL PROTECTED] >>>> Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ >>>> University of Oxford, Tel: +44 1865 272861 (self) >>>> 1 South Parks Road, +44 1865 272866 (PA) >>>> Oxford OX1 3TG, UK Fax: +44 1865 272595 >>> >>> _________________________________________________________________ >>> Your Future Starts Here. Dream it? Then be it! Find it at www.seek.com.au >>> http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Eseek%2Ecom%2Eau%2F%3Ftracking%3Dsk%3Ahet%3Ask%3Anine%3A0%3Ahot%3Atext&_t=764565661&_r=OCT07_endtext_Future&_m=EXT >> >> -- >> Brian D. Ripley, [EMAIL PROTECTED] >> Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ >> University of Oxford, Tel: +44 1865 272861 (self) >> 1 South Parks Road, +44 1865 272866 (PA) >> Oxford OX1 3TG, UK Fax: +44 1865 272595 > > _________________________________________________________________ > Your Future Starts Here. Dream it? Then be it! Find it at www.seek.com.au > http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Eseek%2Ecom%2Eau%2F%3Ftracking%3Dsk%3Ahet%3Ask%3Anine%3A0%3Ahot%3Atext&_t=764565661&_r=OCT07_endtext_Future&_m=EXT -- Brian D. Ripley, [EMAIL PROTECTED] Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595 ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
