Re: [sqlite] Feature suggestion for the Tcl interface : ability to use a list variable in combination with IN

Hi, A very nice extension - I'll look into that one for my integer-only lists, for sure. Thank you! /Fredrik 2011/2/10 Alexey Pechnikov : > See > http://sqlite.mobigroup.ru/wiki?name=ext_intarray_tcl > > 09.02.2011 17:49 пользователь "Fredrik Karlsson"

Re: [sqlite] Feature suggestion for the Tcl interface : ability to use a list variable in combination with IN

On Wed, Feb 9, 2011 at 6:15 PM, Eric Smith wrote: > Fredrik Karlsson wrote: > >> package require sqlite3 >> sqlite3 db :memory: >> db eval {create table a (id INTEGER);} >> db eval {insert into a values (1);} >> db eval {insert into a values (2);} >> db eval {select * from a

Re: [sqlite] Feature suggestion for the Tcl interface : ability to use a list variable in combination with IN

See http://sqlite.mobigroup.ru/wiki?name=ext_intarray_tcl 09.02.2011 17:49 пользователь "Fredrik Karlsson" написал: > Dear list, > > I find the IN operator quite useful for selecting a set number of things. > However, I often have a Tcl list with the things I want to match >

Re: [sqlite] Feature suggestion for the Tcl interface : ability to use a list variable in combination with IN

Fredrik Karlsson wrote: > package require sqlite3 > sqlite3 db :memory: > db eval {create table a (id INTEGER);} > db eval {insert into a values (1);} > db eval {insert into a values (2);} > db eval {select * from a where id in (1,3);} vals {parray vals} > vals(*) = id > vals(id) = 1 > set alist

[sqlite] Feature suggestion for the Tcl interface : ability to use a list variable in combination with IN

Dear list, I find the IN operator quite useful for selecting a set number of things. However, I often have a Tcl list with the things I want to match already when I get to the stage there I should issue a SELECT on the database. I then paste all the elements of the list together with ',' or just