jeudi 7 mai 2015

cursor query gives syntax error for and/or with where clause

I get an SQLite exception in log cat stating that there is a syntax error near "ANDcontraYesOrNo".

Cursor c = db.query( VivzHelper.TABLE_NAME, columns, helper.TX_IDT+"     
='"+name+"' AND" +helper.CONTRA_YES_OR_NO+ "='"+contraY+"' 
OR"+helper.CONTRA_YES_OR_NO+"='"+contraN+"'" +"",null,null, null, NAME + " 
ASC");

Logcat:

at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:641)
at dalvik.system.NativeStart.main(Native Method)
Caused by: android.database.sqlite.SQLiteException: near "ANDcontraYesOrNo":     
syntax error (code 1): , while compiling: SELECT _id, name FROM outtable 
WHERE txidt ='I' ANDcontraYesOrNo='Y' ORcontraYesOrNo='N' ORDER BY name ASC
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native 
Method)

at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnect ion.java:893) at
android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:504) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58) at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:37)

Aucun commentaire:

Enregistrer un commentaire