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