Re: [R] Limited output

2010-07-21 Thread confusedcius
I just found the solution... I used dbGetQuery instead of dbSendQuery. That's a more direct approach and it works. Thanks again for your help. -- View this message in context: http://r.789695.n4.nabble.com/Limited-output-tp2295882p2296822.html Sent from the R help mailing list archive at Nabble.

Re: [R] Limited output

2010-07-21 Thread confusedcius
The details of my problem are as follows: I have an sql that returns 2192 rows in sqlite. In R, I typed the following: > library("RSQLite") > con <- dbConnect(dbDriver("SQLite"), dbname = "C:\\sqlite\\... .sqlite") > dbListTables(con) #[1] "tbl_n..." "tbl_s..."# > cur <- dbSendQuery(con,"sele

[R] Limited output

2010-07-20 Thread confusedcius
Hi there, I entered over 2000 lines of data into R from SQLite and saved it in R as a data.frame, but the data.frame only gives the first 500 lines. Is there any way to either increase the default limit or to determine which of the original lines should be in the output (e.g. maybe the last 500 i