Re: [R] database table merging tips with R

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); Actually,

Re: [R] database table merging tips with R

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 user_id in (select user_id from r_user_id), you would have ... where

Re: [R] database table merging tips with R

to the database. Coey On Thursday, September 11, 2008, at 12:47PM, Coey Minear [EMAIL PROTECTED] wrote: 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

[R] boxplot including null info from dataframe, not with SQLite dataframe

the bounding box nor the axes.) Thanks for any help. -- Coey Minear __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented