[R] RMySQL and R 2.7.0 - "Error in field.types$row.names : $ operator is invalid for atomic vectors"

From: Rainer M Krug <r.m.krug_at_gmail.com>
Date: Thu, 08 May 2008 10:51:50 +0200


when executin the following code, I get an "$ operator is invalid for atomic vectors". I understand the meaning of the error (and have seen the warnings in earlier R versions). My question is, is there an updated version of RMySQL which deals with it, or is my on;ly option to switch to RODBC (which I would not like to do as I am using Linux)? If I have to use RODBC, how can I easily adapt the follolwing code?



> m <- dbDriver("MySQL")
> conn <- dbConnect(m, group = "test")

tblname <- "dummy"
> dat <- data.frame(n1=runif(10), n2=runif(10))
> dbWriteTable(


Error in field.types$row.names : $ operator is invalid for atomic vectors

Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation
Biology, UCT), Dipl. Phys. (Germany)

Plant Conservation Unit
Department of Botany
University of Cape Town
Rondebosch 7701
South Africa

R-help_at_r-project.org mailing list
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Thu 08 May 2008 - 09:02:50 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 08 May 2008 - 10:30:35 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive