[R-sig-DB] (no subject)

[David James]

Jason Horn wrote:
> Does anyone know what this error means:
> 
> "RS-DBI driver warning: (unrecognized MySQL field type 246 in column 1)"
> 

That the data type in column 1 could not be mapped to a known 
R type (type here as in "integer", "double", "logical", ...),
perhaps MYSQL_TYPE_NEWDATE.  If so, a workaround is to extract 
dates as strings, e.g.,

  SELECT CONVERT(all_months_date USING ASCII) as date, ....

and then use you favorite R date/time routine on the output data.frame.

HTH,

--
David


> 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]]
> 
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db