Getting unique item

Problems with WiFi, SQLite ,Bluetooth, WiMax, Proxies, etc...

Getting unique item

Postby metter » Thu Apr 16, 2009 11:58 am

Hello

I need to get items from the sms database for a listing of the most recent messages. Currently, I "get" all messages and loop over them, only showing the first one for each person.

Uri smsUri = Uri.parse("content://sms/");
Cursor smsCursor= managedQuery(smsUri, null,null, null,null);

Is there a way to form the sql statement, so that it only gives me distinct items for a specific column?

Thank you.

Cheers :)
metter
Junior Developer
Junior Developer
 
Posts: 16
Joined: Tue Jan 06, 2009 2:00 pm

Top

Return to Networking & Database Problems

Who is online

Users browsing this forum: No registered users and 5 guests