Hello Simon, First , thank you for responding. Yes maybe in the email i used double quotes, but I have actually tried every quote/ quoteless combination. In fact initially the SQL was in single quotes. It does not work as expected, no results are returned an no error is thrown.
Jason On Mon, Apr 26, 2010 at 10:32 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
