[R-sig-DB] (no subject)
Jason Horn
jhorn @end|ng |rom bu@edu
Thu Mar 2 15:57:07 CET 2006
Does anyone know what this error means:
"RS-DBI driver warning: (unrecognized MySQL field type 246 in column 1)"
Here's the script:
query<-paste("select all_months.date as 'date', avg(all_months.count)
as 'counts' from (select date, time, loc, count(sum) as 'count' from
measurements where sum>0 and year(date)=2000 group by date, loc)
all_months group by all_months.date order by 'date'",sep="")
rs <- dbSendQuery(con, query)
data<-fetch(rs, n=-1)
[[alternative HTML version deleted]]
More information about the R-sig-DB
mailing list