On Tue, 13 Jun 2006, Nathan Johnson wrote: > I'm new to R and have been resisting posting to the list thus far, > but I think I've exhausted my work around options.
Have you asked the package maintainer: the posting guide suggests you do so first? He is by far the most likely source of help. > I'm having a few problems with RMySQL and/or it's underlying packages. Which is DBI by the same author. > I'm doing a very simple vsn transformation on large datasets, using > RMySQL to retrieve the data for a DB. > > My first problem was that I could not get the RMySQL package to write > back to my DB using the dbWriteTable method. > > I constructed a data frame with columns corresponding to the table > fields, and tried with and without a null column for the auto- > increment internal id column. I also tried renaming all the column > names to match those of the table fields. All of my attempts > resulted in a long wait and "TRUE" being printed to the terminal, > which I though was quite promising, however, on inspection of the DB, > I found nothing had been written. So my first question are: > > Is it necessary to provide field names of the table, or will correct > column order suffice? > For tables with an internal auto-increment DBID field, is it > necessary to provide a null column of the correct length? > > To get around this I decided to use the write.table function and then > import via my controlling perl script. This works fine apart from > one problem, numbers >-100000 get printed as exponents, which then > causes subsequent imports to miss these records. So my second and > rather simple question is: > > Is there a setting(options?) which will force full numerical printing? Look for options scipen. -- 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 ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
