I forgot one question. On Tue, 12 Jan 2010 16:12:01 -0500, Qianqian Fang <fan...@gmail.com> wrote:
>One more question, will this work if you have a >long list of ids (say a few hundred)? There is a maximum list size the parser can cope with. Internally "id IN (val1,val2,...valN)" is converted to "WHERE id = val1 OR id = val2 OR .... id = valN" http://www.sqlite.org/limits.html I think here 5. Maximum Depth Of An Expression Tree applies, which defaults to 1000. Experiment to verify ;) >thanks > >Qianqian -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
