Hello, I'm new to both Java, Android and programming altogther. I have begun to make my first program and, with the help of these forums, have learnt A LOT. Thanks.
Although I have one thing that I'm stuck on. I would like to query a database by the field "group_number".

I have the following code which returns all the rows where "group_number" = CRITERIA (when CRITERIA = one integer).

Code: Select all

    public Cursor fetchRows() throws SQLException {

 
       Cursor cursor =
       
       mDb.query(true, type, new String[] {"_id",
                       "field_1", "field_2", "example", "group_number"}, "group_number" + "=" + CRITERIA, null,
                        null, null, null, null);
       
return cursor;


However I also have an ArrayList containing serveral integers and I'd like to return rows which have a "group_number" equal to any of the numbers in the ArrayList.

So far all I've done is replace CRITERIA with the name of my ArrayList but it's not working.

Would anybody be kind enough to show me how to do this?

p.s sorry for the bad explanation.

Thanks.

Don't know about providing lists in the query, but the simpliest way is to iterate through the list and build a selection string;

Edit:

Here's from the tip of my head. Probably should work, though you might want to edit code a little since it's pretty basic:



And your code with this method:

Hey, thanks for the quick reply Alaxandro. I haven't tried it yet but I'm sure it'll work.

I'll give it ago when I've got spare minute. Cheers again.