[R] R, RMysql, and MySQL 5 Decimal Type Support

[Robert Baer]

> Whenever I have a MySQL query that returns a Decimal result to R I get
> the following warning in R:
> I get this for a simple query like "SELECT 2, 2.5" !!
> Warning message:
> RS-DBI driver warning: (unrecognized MySQL field type 246 in column 1)
>
If I understand  what you are saying, I think you have garbled SQL syntax.
The select statement synatx is:

SELECT list_of_columns FROM tables[s] [WHERE search_conditions]

My guess is that you don't have columns named 2 or 2.5

Rob
____________________________
Robert W. Baer, Ph.D.
Associate Professor
Department of Physiology
A. T. Still University of Health Science
800 W. Jefferson St.
Kirksville, MO 63501-1497 USA
----- Original Message ----- 
From: "Jason Trimble" <jason at bodymedia.com>
To: <r-help at stat.math.ethz.ch>
Sent: Tuesday, March 28, 2006 12:08 PM
Subject: [R] R, RMysql, and MySQL 5 Decimal Type Support


> Hi,
>
>
>
>
>
>
>
>

>
>
>
> I am using:
>
> R ver 2.1.1
>
> RMySQL ver. 0.5-7
>
> DBI ver. 0.1-10
>
> MySQL  Ver 14.12 Distrib 5.0.18.
>
>
>
> Please Help!
>
> Jason
>
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html
>