On Fri, 7 Mar 2008 14:34:53 -0500 (EST), you wrote: > sqlite3 test.db `select name from PerfTest1 where name = "key5000"'
In SQL, a string should be delimited with single quotes, not double quotes. Try: sqlite3 test.db "select name from PerfTest1 where name = 'key5000' " or echo "select name from PerfTest1 where name = 'key5000' " | sqlite3 test.db -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users