Hi, is there a way to bind vectors to DBI query parameters? The
following tells me that vectors are sent as separate values:
> library("RSQLite")
> c <- dbConnect (SQLite())
> dbGetQuery(c, "create table tst (x int, y int)")
> dbGetQuery(c, "insert into tst values (?, ?)", data.frame(x=c (1,2,1,2),
> y=c(3, 4, 5, 6)))
> dbReadTable(c, "tst")
x y
1 1 3
2 2 4
3 1 5
4 2 6
> dbGetQuery(c, "select * from tst where y not in (?)", c(7,6))
x y
1 1 3
2 2 4
3 1 5
4 2 6
5 1 3
6 2 4
7 1 5
This looks like 2 result sets (4 + 3 entries), not one.
Is there to send multiple values to a '?' binding? Is this at all
possible using the R DBI interface (not necessarily with rsqlite)?
______________________________________________
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, minimal, self-contained, reproducible code.
