I tried something for kicks and it worked. I flipped all the column definitions from VARCHAR(255) to INTEGER and my query, above, works properly. I did a little reading and found this described my problem: http://www.sqlite.org/datatypes.html .
Q: Is their some inverse problem now that all the columns are defined as INTEGER? Is there anything that might go wrong with a casual query of mostly or all string values in a column that's declared INTEGER? -- View this message in context: http://www.nabble.com/WHERE-clause-doesn%27t-seem-to-work-right-tp22497543p22497796.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
