search for: quicksql

I have a problem when using the RMySQL package and the methods package together (R version 1.5.0) I do : library(RMySQL); m<-dbManager('MySQL') con<-dbConnect(m); quickSQL(con, ' select blah blah..'); This works fine . However when I then do: library(methods); and then repeat my sql : quickSQL(con, ' select blah blah..'); I get the following error: Error in getClass(Class) : "MySQLResultSet" is not a defined class. Is this a bug or am I...

...: Redhat 7.1 2.96-85 Submission from: (NULL) (131.220.6.43) There is a bug when retrieving values out of MySQL (3.23.36) which are of type UNSIGNED INTEGER(10). The values can vary between 0 and 2^32 but R only accepts those below 2^31-1. Anything above goes as 2^31-1. thats what one gets: print(quickSQL(con,"select ip_dst from iphdr where ip_dst>=2212233216 limit 5")) ip_dst 1 2147483647 2 2147483647 3 2147483647 4 2147483647 5 2147483647 and thats what the numbers really are (conversion to character type first): print(quickSQL(con,"select concat(ip_dst) from iphdr where i...

Hi All, As a part of our regular data analysis, I have to read in large data sets with six columns and about a million rows. In Splus, this usually take a couple of minutes. I just tried R, it seems take forever to use read.table() to read in the data frame! It did not help much even though I specified colClasses and nrows in read.table(). How is R's ability to analyze large data sets? I

Hi all, This is a potentially very stupid question about MySQL <-> R interaction, but I have not been able to solve it. I'm just trying to connect R to my MySQL databse, and gets this: > library(RMySQL) Loading required package: methods > m <- dbDriver("MySQL") > con <- dbConnect(m,group="testdb") Process R segmentation fault at Wed Oct 16 07:04:30