jeudi 26 mars 2015

sqlite fetch statement

Good day,


I need to fetch rows from my sqlite table, but I need to pass multiple parameters. This is my statement that does not work.



SELECT * FROM messages WHERE currentuser=\"%@\" AND (belongstouser=\"%@\" OR mymsgforuser=\"%@\") ORDER BY ID ASC


I need it to first check for the currentuser match, then out of those matches to check for either the belongstouser or mymsgforuser matches. Is it possible to nest a sqlite statement in this fashion? I tried removing the parenthesis and that didn't work either. I also searched the sqlite documentation and could not find a solution.


Aucun commentaire:

Enregistrer un commentaire