[R-sig-DB] dbSendPreparedQuery in RSQLite

[Sean Davis]

On Tue, Apr 15, 2008 at 8:31 PM, James Bullard <bullard using 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@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