dimanche 26 avril 2015

How to get the rows where table contains one or more variables

I have table with columns Id, Name and Description

I have String:

String values = "banana, apple"

Now I want to get all the rows, where column Desctiption contains both "apple" and "banana" word.

I used this code:

 public List<Flavours> getNeedFlavours(String text) {
        List<Flavours> flavoursList = new ArrayList<Flavours>();
        // Select All Query
//        String selectQuery = "SELECT " + KEY_DATE + " FROM " + TABLE_TV_PROGRAMM;

        String table = TABLE_FLAVOURS;
        String where = KEY_DESCRIPTION + " = ?" ;
        String[] args = text.split(",");


        SQLiteDatabase db = this.getWritableDatabase();
        Cursor cursor = db.query(table, null, where, args, null, null, null);


        // looping through all rows and adding to list
        if (cursor.moveToFirst()) {
            do {
                Flavours flavours= new Flavours();
                flavours.setID(Integer.parseInt(cursor.getString(0)));
                flavours.setName(cursor.getString(1));
                flavours.setDescription(cursor.getString(2));


                // Adding contact to list
                flavoursList.add(flavours);
            } while (cursor.moveToNext());
        }

        // return channels list
        return flavoursList;
    }

But I'm getting this error:

android.database.sqlite.SQLiteBindOrColumnIndexOutOfRangeException: bind or column index out of range: handle 0x21443d8
            at android.database.sqlite.SQLiteProgram.native_bind_string(Native Method)
            at android.database.sqlite.SQLiteProgram.bind(SQLiteProgram.java:247)
            at android.database.sqlite.SQLiteProgram.bindString(SQLiteProgram.java:299)
            at android.database.sqlite.SQLiteProgram.bindAllArgsAsStrings(SQLiteProgram.java:401)
            at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:55)
            at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:58)
            at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1653)
            at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1538)
            at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1494)
            at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1574)
            at uz.ugadaykin.hookah.db.DatabaseHandler.getNeedFlavours(DatabaseHandler.java:175)
            at uz.ugadaykin.hookah.fragment.FlavoursFragment.makeListView(FlavoursFragment.java:87)
            at uz.ugadaykin.hookah.fragment.FlavoursFragment$1.onClick(FlavoursFragment.java:69)
            at android.view.View.performClick(View.java:3549)
            at android.view.View$PerformClick.run(View.java:14400)
            at android.os.Handler.handleCallback(Handler.java:605)
            at android.os.Handler.dispatchMessage(Handler.java:92)
            at android.os.Looper.loop(Looper.java:154)
            at android.app.ActivityThread.main(ActivityThread.java:4944)
            at java.lang.reflect.Method.invokeNative(Native Method)
            at java.lang.reflect.Method.invoke(Method.java:511)
            at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
            at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
            at dalvik.system.NativeStart.main(Native Method)

How I can solve this problem???

Aucun commentaire:

Enregistrer un commentaire