If what you really want is to retrieve contact with id=1, you should
provide an URI like "content://android.provider.people/1".
People.CONTENT_URI provides you the first part of the URI ("content://
android.provider.people"). Then, you just need to add which ID you
want with something like this:
Uri uri =
ContentUris.withAppendedId(org.pinowsky.provider.Items.CONTENT_URI,
rowID);
Cursor c = getContentResolver().query(uri,PROJECTION, null, null);
Did not try that code but it should be something like that...check the
ApiSamples
br
On Mar 23, 4:30 am, xinexo <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I'm trying to query contact by id with this simple code
>
> private static String[] PROJECTION = new String[] {
> People._ID, People.NAME, People.NUMBER
> };
>
> Cursor c = getContentResolver().query(People.CONTENT_URI,
> PROJECTION,
> People._ID + "=1", null, null);
>
> and i got this exception...
>
> ERROR/JavaBinder(545): android.database.sqlite.SQLiteException:
> ambiguous column name: _id, while compiling: SELECT COUNT(*) FROM
> (SELECT people._id AS _id FROM people LEFT OUTER JOIN phones ON
> people.preferred_phone=phones._id LEFT OUTER JOIN presence ON
> (presence.person=people._id) WHERE (_id=1))
>
> if i changed People._ID + "=1" to People.NUMBER, it works!
>
> Please help...
>
> Thanks
>
> xinexo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
Announcing the new M5 SDK!
http://android-developers.blogspot.com/2008/02/android-sdk-m5-rc14-now-available.html
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
