[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


Hi

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?

Thanks

Rainer

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

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

               conn,
               tblName,
               dat,
               overwrite=FALSE,
               append=TRUE
               )

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
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.
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