Message-ID: <264855a00804151921r571d3a55i1170450f43a1bc91@mail.gmail.com>
Date: 2008-04-16T02:21:33Z
From: Sean Davis
Subject: dbSendPreparedQuery in RSQLite
In-Reply-To: <F1929BAE-218E-4A7C-9EBF-EA04CAD13448@berkeley.edu>
On Tue, Apr 15, 2008 at 8:31 PM, James Bullard <bullard at berkeley.edu> wrote:
> How do we send prepared queries in RSQLite. We are interested in
> something along the lines of
>
> ps = dbSendPreparedQuery(conn, "SELECT * FROM table1 WHERE chr = ?",
> data.frame("integer"))
> for( i in 1:2)
> rs = dbGetPreparedQuery(ps, i)
>
> In C it would look something along the lines of
> http://www.mail-archive.com/sqlite-users at sqlite.org/msg31854.html
It looks like this is not supported for select statements, though I
could easily be wrong. In this particular case, you could rewrite
your select as:
"SELECT * from table1 where chr in (1,2)"
Sean