Error when read Android contacts

Question

I've gotten this snippet from StackOverflow:

Cursor people = getContentResolver().query(
            ContactsContract.Contacts.CONTENT_URI, null, null, null, null);

    try{
        while (people.moveToNext()) {
            int nameFieldColumnIndex = people
                    .getColumnIndex(ContactsContract.CommonDataKinds.Phone.DISPLAY_NAME);
            String contact = people.getString(nameFieldColumnIndex);
            int numberFieldColumnIndex = people.getColumnIndex(ContactsContract.CommonDataKinds.Phone.NUMBER);
            String number =  people.getString(numberFieldColumnIndex);

            System.out.println(contact + "-" + number);
        }
    }catch(Exception e){
        System.out.println(e);
    }
    people.close();

When I try to read phoneNum column I get an error using String number = people.getString(numberFieldColumnIndex). Checking the column index I find that numberFiledColomnIndex = -1.

How can I get this snippet working?

inside `while (people.moveToNext()) {` add DatabaseUtils.dumpCurrentRow() in order to see the columns — pskink, Apr 11 '15 at 06:06
Good question - but it sounds like the first getColumnIndex() (name field) is working. This would imply the manifest permissions are probably OK. IMHO... — FoggyDay, Apr 11 '15 at 06:07
http://stackoverflow.com/questions/25717989/cannot-retrieve-email-from-contacts — kgandroid, Apr 11 '15 at 07:08

score 0 · Accepted Answer · answered Apr 11 '15 at 06:02

0

Per the documentation, getColumnIndex() returns -1 when the column doesn't exist.

Q: Are you passing the correct column name? Is the spelling correct?

answered Apr 11 '15 at 06:02

FoggyDay

11,962
4
34
48

@user4769924 - Strong suggestion: step through the debugger. Check the values of your actual database column fields; check the spelling of the value you're passing to getColumnIndex(). The entire problem could be a typo. – FoggyDay Apr 11 '15 at 06:08

Error when read Android contacts

1 Answers1