ry option, unless you find that ODBC, or RODBC, has a
limit on what can be sent 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
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 u
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");
>
either try to install RSQLite on Windows or get
postscript working on FreeBSD. (My quick attempt with postscript in R
on FreeBSD was not drawing the bounding box nor the axes.)
Thanks for any help.
--
Coey Minear
__
R-help@r-project.org mailing list
4 matches
Mail list logo
