Hi James, > / > 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 may work, but it's still wrong ;-) You should use single quotes for literals, which is correct SQL syntax. SQLite should give an error for double quotes unless it's a column or table name. SQLite doesn't generate an error, unfortunately, because it allows for some cross compatibility with MSSQL or something that permits double quoted literals. That allowance, however, is not standard SQL and causes a host of problems. I'm hoping it will be removed from SQLite. Tom BareFeet _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
