Search Archives
Search tips
from:Name
Search by author name, e.g. from:Duncan Murdoch
"exact phrase"
Match an exact phrase
word1 word2
Match messages containing both words
Date range
Use the date pickers to filter results to a time period
Use the list dropdown to narrow results to a specific mailing list. Combine from: with other terms to filter by author and content.
Avram Aelony writes: > > I have not devoted time to setting up ROracle since binaries are > not available and it seems to require some effort to compile (see > http://cran.r-project.org/web/packages/ROracle/index.html). On the > other...
Aaron Mackey writes: > I guess I'd do it something like this: > > dbGetQuery(con, "CREATE TEMPORARY TABLE foo ( etc etc)") > sapply(@userids, function (x) { dbGetQuery(con, paste("INSERT INTO foo > (userid) VALUES (", x, ")")) }) > > then later: > > dbGetQuery(con, "DROP TABLE foo...
While the subquery with a temporary table is probably the better option, you could just manually generate the subquery and pass it in with the query. As an example, if you have user_ids 1000-1005, instead of having "... where...
I have been trying to use R to gather some information from parsed log files (as part of examining some performance issues). I parsed the log files and put the data into an SQLite database, and then used RSQLite to...
Can't find what you're looking for? Try searching with Google .