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 <pechni...@mobigroup.ru>: > See > http://sqlite.mobigroup.ru/wiki?name=ext_intarray_tcl > > 09.02.2011 17:49 пользователь "Fredrik Karlsson" <dargo...@gmail.com> > написал: >> 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 , >> chars and supply that inside a () to the sqlite3 database command. >> >> Would it not be a nice, and safer, addition to the interface to be >> able to do something like this (i.e. sot that there would be no syntax >> error at the end): >> >> -------------- >> 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 [list 1 3] >> 1 3 >> db eval {select * from a where id in $alist;} vals {parray vals} >> near "$alist": syntax error >> -------------- >> >> Also seems much safer to have a proper binding of values here.. >> >> /Fredrik >> >> >> >> -- >> "Life is like a trumpet - if you don't put anything into it, you don't >> get anything out of it." >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- "Life is like a trumpet - if you don't put anything into it, you don't get anything out of it." _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
