On 26 Apr 2010, at 3:17am, jason d wrote: > when I use > > Select * from names where "name" = "bob"; > > it works fine. but whenever I use "name" = "diana-rogers"
SQLite uses single quotes for strings, not double quotes. And the thing 'name' is meant to be the name of a column, not a fixed string. So try something like SELECT * FROM names WHERE name = 'bob' and see if that works any better. > the column name is TEXT type (if that means anything is sqlite) > I have tried with VARCHAR but I get the same result. SQLite doesn't have a VARCHAR type. It interprets it as identical to TEXT. Won't do any harm to called it VARCHAR, I'm just telling you there's no point in trying it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
