R help - Oct 2009 - 'dbSendQuery' or 'dbGetQuery' error from library 'RMySQL'

Dear R users,


Basically, I desire to extract more than 1 column from a table in MySQL
database.

However, I get a pop-up error reading *"R for Windows GUI front-end has
encountered a problem and needs to close. We are sorry for the
incovenience."* when there are more than 1 field following
"SELECT" phrase
in the "dbSendQuery" function.

Scripts below was used,

*library(DBI)
library(RMySQL)*
* *
*con <- dbConnect(MySQL(), user="XXX", password="XXX",
dbname="XXX",
host="XXX")*
* *
*foo <- dbSendQuery(con, "SELECT pol, claims FROM GI.marine ORDER BY
pol"
)           *
*GI <- fetch(foo,n = -1)*


When I specify only 1 field (i.e *foo <- dbSendQuery(con, "SELECT pol
FROM GI.marine
ORDER BY pol"* ), it gives the desired query result without any error.

Your advise on resolving this issue would be highly appreciated.






Steven

	[[alternative HTML version deleted]]