Hello, 

I am trying to insert data in a data.frame into a database table using the RMySQL package

m <- dbDriver("MySQL")
con <- dbConnect(m, host = "blah", user = "blah", password = "blah", dbname = "blah")

    proid <- dbGetQuery(con, "select max(processed_data_id)+1 from processed_data")                     
    spot  <- array.norm$arrayValues$spot_index
    name  <- array.norm$arrayValues$name
    log   <- array.norm$arrayValues$LogRatioNorm
    snr   <- array.norm$arrayValues$snr
    empty <- NA
    insert <- data.frame(proid, spot, name, empty, empty, log, snr, empty, empty)
    dbWriteTable(con, "processed_data", insert, append=TRUE, row.name=FALSE)
    dbCommit(con)

the table i am trying to insert into:

CREATE TABLE `processed_data` (
  `processed_data_id` int(6) unsigned NOT NULL,
  `data_id` int(6) unsigned NOT NULL,
  `feature_name` varchar(100),
  `channel1_signal` int(5),
  `channel2_signal` int(5),
  `log2_ratio` double(5,2),
  `flag` varchar(100),
  `chr_copy_num` double(5,2),
  `significance` double(7,4),
  PRIMARY KEY (`processed_data_id`,`data_id`)
) 

Can anyone explain why i am getting this error?

 Error: '.class1' is not implemented yet
In addition: Warning message:
In data.frame(proid, spot, name, empty, empty, log, snr, empty,  :
  row names were found from a short variable and have been discarded
Execution halted

OS: Windows XP
R: 2.6.0
MySQL: 5

Thanks,

James Morris
	[[alternative HTML version deleted]]

