[R] RODBC sqlQuery question
sdavis2 at mail.nih.gov
Tue Jan 17 14:31:30 CET 2006
Why does this happen when I do a sqlQuery?
Version 2.3.0 Under development (unstable) (2006-01-04 r36984)
attached base packages:
 "methods" "stats" "graphics" "grDevices" "utils" "datasets"
other attached packages:
> b <- sqlQuery(con,"select * from HartProbe where PROBE_ID='Hart19'")
I get output for each row returned. In this case, the table has a million
rows, so I can't really select from it reasonably. It doesn't look to me
like sqlQuery or sqlGetResults has a verbose option to turn off such output.
More information about the R-help