Hi there everyone, its very hard to find sqlite users so I am glad I joined this mailing list. Recently it seems a lot of people are using sqlite which I dont get but anyways.
I am still using sqlite2 as the libraries I use do not support sqlite3 (yet). I am using it for web development. I ran into a strange problem recently. seems like a bug but i am no guru on sql internals. so here goes. Lets say I have a colum "names" and have values "bob", "jones" and "diana-rogers" when I use Select * from names where "name" = "bob"; it works fine. but whenever I use "name" = "diana-rogers" or anything with a dash in it, it wont work. I have tried with PHP and with command line (linux) but there is no error and i get return values as if there really does not exist this filed. the column name is TEXT type (if that means anything is sqlite) I have tried with VARCHAR but I get the same result. I have hit a brick wall with this problem and have been at it for a couple of weeks. trying everything I know and can see on gazillionth google search. If anyone has any info on this and can please share it will be deeply appreciated and given virtual cookies :D regards Jason. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
