Displaying 1 result from an estimated 1 matches for "dcumrec".
Did you mean:
fcumrec
2010 Apr 30
0
RMySQL and dates
...ing to read and write database tables that have a date field in
them.
I am constructing a data.frame, then using dbWriteTable to create the
table and dbReadTable to read it.
>datatbl<-data.frame( dates, trialnum, fooddel, ethdel, trialtime,
trialtype, deliveries, food, ethanol, fcumrec, dcumrec, rrf, rrd)
>ifelse(startdate==filelist, filetbl<-datatbl,filetbl<-rbind(filetbl,
datatbl))
>dbWriteTable(con, subj, as.data.frame(filetbl), overwrite=T)
This creates the table named for the contents of subj...the problem is
in the class of the first column, dates.
> sapply(f...