Thanks goes out to both of you for your quick responses! For text in SQLite, delimit with single quotes, not double quotes. Double > quotes are used for tricky entity names. And you probably don't want the > quotes around the real numbers at all.
I'll go off and re-read up on the quotes and make sure I use them correctly. And you're correct, I didn't want the quotes around the real numbers, they were put in there when I was putting together and testing my sample database. But not in the real database. *facepalm* I think I'll spend the time going back and storing the dates as integer time (since the epoch) as Nico suggested and just use strftime to convert them as and when required. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
