[R] RMySQL fetch defaults to N=500?
Jay Pfaffman
pfaffman at relaxpc.com
Fri Aug 9 02:07:43 CEST 2002
It appears that fetch() gets only the first 500 rows by default. I
don't see this in the documentation, but
timeinfo <- fetch(rs)
gets only 500 rows where
timeinfo <- fetch(rs,n=-1)
gets (correctly) 736 for the same query. Is this an undocumented
feature? I played with this data for an alarming amount of time
before I realized that I was missing a third of the data. I appear to
be using version 0.4-5. I'll upgrade to 0.4-6 Real Soon Now. My
first attempt failed for some reason.
--
Jay Pfaffman pfaffman at relaxpc.com
+1-415-821-7507 (H) +1-415-810-2238 (M)
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
More information about the R-help
mailing list