Message-ID: <19CEF653-CA92-49BB-B557-519EC954BF3C@berkeley.edu>
Date: 2008-04-16T03:45:42Z
From: James Bullard
Subject: dbSendPreparedQuery in RSQLite
In-Reply-To: <264855a00804151921r571d3a55i1170450f43a1bc91@mail.gmail.com>
Yes, in this example that would certainly work. However, I have a
large number of queries in a tight loop and it would be nice to avoid
the overhead of the query parsing and compiling on each call through
the loop. I believe it is not supported on select statements as well
and wonder if this would be a hard addition, also, I wonder if this is
the correct syntax below. From other settings it seems a little off
(see the link in the original email).
thanks again, jim
On Apr 15, 2008, at 7:21 PM, Sean Davis wrote:
> 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