On Mon, Apr 26, 2010 at 10:32 AM, Simon Slavin <[email protected]> wrote: > >> SELECT * FROM names WHERE name = 'bob'
On 26 Apr 2010, at 3:54am, jason d wrote: > Hello Simon, > First , thank you for responding. You're welcome. New text below the text you're quoting, please. English is read top to bottom. > 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. You do not want quotes of any kind around 'name'. Try it exactly as I wrote it below and see if that works. > It does not work as > expected, no results are returned an no error is thrown. Then you have no records in your table that match your search criterion. Are you sure you really do have a record for 'bob' ? How do you prove it ? Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
