> 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" <[EMAIL PROTECTED]> To: <[email protected]> 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]] > > ______________________________________________ > [email protected] mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html > ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
