Android sql query

Question

i have this selection query to fetch rows from the sqlite database of android phone contacts.

String selection = ContactsContract.Data.MIMETYPE + " = '" + ContactsContract.CommonDataKinds.Phone.CONTENT_ITEM_TYPE + "'"
           + " AND "+ContactsContract.Data.DATA10+ " = '" + select + "'";

Log.d(LOG_TAG,"selection in update data"+selection);

c = mContext.getContentResolver().query(CONTENT_URI, Projection,selection, null, null);

where select = +12244004242

I am successfully able to fetch the reqd data. However my requirement is if i have more than one string. i.e an array of strings.how do i write the query?

I was tring with

String selection = ContactsContract.Data.DATA10 IN ("+select+")";

where select = +12244004242,+12244004245,+12244004248

however i am not getting any values.please help me write the selection query.

are those Ids you are trying to select? What is the Id field name. — IAmGroot
– IAmGroot, Commented Jul 4, 2012 at 8:46

Benito Bertoli · Accepted Answer · 2012-07-04 08:50:14Z

1

Try to use IN(" + select + ")

with select = "'+12244004242','+12244004245','+12244004248'"

answered Jul 4, 2012 at 8:50

Benito Bertoli

25.9k12 gold badges56 silver badges63 bronze badges

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

2 Comments

scooby Over a year ago

I tried that.. i have written in the original problem statement.. but then cursor.getcount() was 0.

Benito Bertoli Over a year ago

Notice that I've added single quotes to the numbers. Perhaps that was what you were missing.

biddulph.r · Accepted Answer · 2012-07-04 08:31:15Z

0

You can do a nested OR:

so:

select = +12244004242 OR select=+12244004245 OR select=+12244004248

answered Jul 4, 2012 at 8:31

biddulph.r

5,2663 gold badges34 silver badges47 bronze badges

2 Comments

scooby Over a year ago

No, actually i am just giving an example. in my code i dont know the number of elements in the string.i.e i dont know the count of the numbers in the String select.Can I use IN clause??

biddulph.r Over a year ago

Well you could iterate through the list and populate with OR statements, or you could look for a more efficient approach than writing the SQL like this, have you tried using the cursor.query method, adding the selection text with "?" symbols and using these in the selectionArgs parameter to populate the fields?

SingleWave Games · Accepted Answer · 2012-07-04 09:33:11Z

0

You could try using transaction queries, this is how i went about extracting data from my sqlite database, something like:

db = window.openDatabase("DBID", "1.0", "DBName", 50000000);
db.transaction(TableName, errorCB, successCB);
tx.executeSql('SELECT Col1, Col2 FROM TableName WHERE Col1="'+ test +'";', [], querySuccess, errorCB);

function querySuccess(tx, result) 
{
    // DO SOMETHING HERE
}

function errorCB(tx, err) {
    alert("Error processing SQL: "+err.message);
}

answered Jul 4, 2012 at 9:33

SingleWave Games

2,6589 gold badges38 silver badges53 bronze badges

Collectives™ on Stack Overflow

Android sql query

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related