开发者

All contacts that have more than one phone number

开发者 https://www.devze.com 2023-03-13 20:24 出处:网络
I\'m trying to get all the contacts that have more than one phone number. Using sqlite3, I queried the database like this:

I'm trying to get all the contacts that have more than one phone number. Using sqlite3, I queried the database like this:

select number,name,person,type 
  from view_v1_phones 
  where person in 
  (select person from view_v1_phones group by person having count(*)>1);

and got what I was looking for. However, I don't know how I can use this when I'm querying the database using contacts api (ContactsCon开发者_开发百科tract).

Help!


Here is a link I found when I was working on something similar. This one is a pretty comprehensive guide to contacts in android. It is a 6-page guide! Hope this helps:

http://www.higherpass.com/Android/Tutorials/Working-With-Android-Contacts/1/

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号