Skip to content
Prev 343054 / 398506 Next

pass vector binding to DBI parameter (rsqlite)

Hi, is there a way to bind vectors to DBI query parameters? The
following tells me that vectors are sent as separate values:
x y
1 1 3
2 2 4
3 1 5
4 2 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)?