limiting number of rows in a ContentResolver.query() function

by

To limit the number of results in your cursor try:

cursor = cr.query(ContactsContract.Contacts.CONTENT_URI,null, null, null, ContactName + " LIMIT 100");
while(cursor.moveToNext()) {
    // something clever
}

Related Contents:

  1. How can I avoid concurrency problems when using SQLite on Android?
  2. Best way to work with dates in Android SQLite [closed]
  3. Pros and Cons of SQLite and Shared Preferences [closed]
  4. How do I view the SQLite database on an Android device? [duplicate]
  5. How to call Android contacts list?
  6. Android: upgrading DB version and adding new table
  7. Retrieve database or any other file from the Internal Storage using run-as
  8. How to read contacts on Android 2.0
  9. How does one check if a table exists in an Android SQLite database?
  10. How to store JSON object in SQLite database
  11. Android SQLite database: slow insertion
  12. Where does Android store SQLite’s database version?
  13. How to add new Column to Android SQLite Database?
  14. Android backup/restore: how to backup an internal database?
  15. Android database encryption
  16. Send text to specific contact programmatically (whatsapp)
  17. Query if Android database exists!
  18. Read all contacts’ phone numbers in android
  19. What is difference between SQLite and SQL
  20. IllegalArgumentException: the bind value at index 1 is null
  21. Best place to close database connection
  22. Drawable to byte[]
  23. Cursor adapter and sqlite example [closed]
  24. Share SQLite database between 2 android apps?
  25. Android SQLite Example [closed]
  26. How do I update an android sqlite database column value to null using ContentValues?
  27. Android contacts Display Name and Phone Number(s) in single database query?
  28. SQLiteOpenHelper onUpgrade() Confusion Android
  29. How to delete object from Realm Database Android?
  30. When to close db connection on android? Every time after your operation finished or after your app exit
  31. Multiple tables with same type of objects in Room database
  32. Android Spinner: Get the selected item change event
  33. Android webview & localStorage
  34. Which Architecture patterns are used on Android? [closed]
  35. Android: ScrollView vs NestedScrollView
  36. Android Paint: .measureText() vs .getTextBounds()
  37. Best way to add Activity to an Android project in Eclipse?
  38. Sign APK without putting keystore info in build.gradle
  39. What exactly does the post method do?
  40. Android Studio could not find any version that matches com.android.support:appcompat-v7:+
  41. support FragmentPagerAdapter holds reference to old fragments
  42. Android Studio – debug keystore
  43. Android – Activity vs FragmentActivity? [duplicate]
  44. Android Studio: Background task running indefinitely
  45. Android accelerometer not working when screen is turned off
  46. How SurfaceHolder callbacks are related to Activity lifecycle?
  47. Android popup window dismissal
  48. DialogFragment and force to show keyboard
  49. What’s the difference between lineSpacingExtra and lineSpacingMultiplier?
  50. How to use Kotlin with Proguard

Leave a Comment