dimanche 4 janvier 2015

WHERE + AND query doesn't work SQLite

Im trying to select some values from my table, but it returns 0 rows. If I comment one of clauses - it works, but when I add "and" it doesnt.


Here is my code



cursor = mValtoneDB.mDataBase.rawQuery("select activity.name as name, activity._id as id " +
"from activity inner join discipline " +
"on discipline._id = activity.disciplineId " +
"inner join user_discipline_lt " +
"on discipline._id = user_discipline_lt.disciplineId "
+ "where" +
" user_discipline_lt.userId=? " +
"and" +
" discipline._id=?"
, new String[] { Integer.toString(userId), Integer.toString(disciplineId) }


I dont know what to do :\


Aucun commentaire:

Enregistrer un commentaire