SQLite Where IN followed by variable String

Question

I have the variable string (user gets to set it via a ListView with tickboxes, so string can contain any number of fruits)

    private static final String kernset = "Banana, Peach"

I have the following SQLite Query

          Cursor cursor = db.query (TABLE_NAME, new String[] {
        WOORD },
        "kern IN (\"Banana\", \"Apple\")", null, null, null, null, null);

I want to replace the (\"Banana\", \"Apple\") part of the query with the variable.

How should I do that?

Thanks!

Vladimir · Accepted Answer · 2011-10-31 14:22:15Z

3

If you want to place a variable into your selection parameter, you can split your string using split method, and then form your selection like

StringBuilder sb = new StringBuilder();
sb.append("kern IN (");
String[] inItems = kernset.split("\\,\\s+");

for (int i=0; i < inItems.length; i++){
    if (i > 0)
        sb.append(", ");
    sb.append("'" + inItems[i] + "'");
}
sb.append(")");
String selection = sb.toString();

however if you wish to use ? in selection and replace it with selectionArgs[] it seems to be imposible since values passed in selectionArgs are surrounded with ' '. You can however form selection with ? instead of actual values (like kern IN (?, ?, ?))and then pass inItems via selectionArgs[]

edited Oct 31, 2011 at 14:22

answered Oct 31, 2011 at 13:13

Vladimir

9,7636 gold badges38 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kees Koenen Over a year ago

Thanks! Never would have figured this out by my own.. I had to add sb.append(")"); to get the closing ). Current (working) code : ` for (int i=0; i < inItems.length; i++){ if (i > 0) sb.append(", "); sb.append("'" + inItems[i] + "'"); } sb.append(")"); String selection = sb.toString();` -- PLEASE edit your solution to add the ), so I can mark it correct. Thanks!

Vladimir Over a year ago

no problem =) sorry I missed that line while copying the code

score 0 · Accepted Answer · 2011-10-31 13:29:10Z

0

by just using concatenation like

 Cursor cursor = db.query (TABLE_NAME, new String[] {
    WOORD },
    "kern IN (\""+var1+"\", \""+var2+"\")", null, null, null, null, null);

for unknow no of vars

inString="";
   for(int i=0;i<fruits.length();i++)
    {
        inString=inString+"\""+fruits[i]+"\"";
        if(i<(fruits.length()-1))
      {
         inString=inString+", "
      }
    }


        Cursor cursor = db.query (TABLE_NAME, new String[] { WOORD },
            "kern IN ("+inString+")", null, null, null, null, null);

edited Oct 31, 2011 at 13:29

answered Oct 31, 2011 at 13:05

user1016058

2 Comments

Kees Koenen Over a year ago

For unknown no of vars; I get errors, missing ; on line 7, inString cannot be resolved to a variable, Type of expression must be Array, but resolved to String..

user1016058 Over a year ago

then just put ; after line like inString=inString+", ";

Collectives™ on Stack Overflow

SQLite Where IN followed by variable String

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related