For SQL it needs to be 'key5000' not "key3000". James Kimble wrote: > On the command line: > > / > sqlite3 test.db `select name from PerfTest1 where name = "key5000"' > > does work. I know this because if I query for "key500" I get back that > row. It's not blanks either because if I > do: > > where name link "key1%" > > I only get rows prior to "key199". Very weird. I did try the other > alternatives (single quotes and piping into > sqlite3 test.db) but got the same result. > > I'll try changing the varchar to TEXT. See if that makes a difference.... > _______________________________________________ > 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