Android Sqlite selection args[] with int values

by

The answer is in the title: you are trying to pass integer values into the query, but what you actually end up with are string values.

This is a horrible design bug in the Android database API; you can use parameters only for strings.

Integer numbers do not have the formatting and SQL injection problems that string values would have, so you can just insert the numbers directly into the SQL expression:

Cursor c = database.query(
    DATABASE_TABLE, columns, 
    KEY_YEAR  + "=" + year  + " AND " +
    KEY_MONTH + "=" + month + " AND " +
    KEY_DAY   + "=" + day,
    null, null, null,
    KEY_MONTH + "," + KEY_DAY);

(And the orderBy syntax was wrong.)

More Related Contents:

  1. I am getting this error on my code [closed]
  2. Sqlite for Android
  3. How can I avoid concurrency problems when using SQLite on Android?
  4. How to store(bitmap image) and retrieve image from sqlite database in android? [closed]
  5. Best way to work with dates in Android SQLite [closed]
  6. Android SQLite Example [closed]
  7. How do I join two SQLite tables in my Android application?
  8. How can I create a user-defined function in SQLite?
  9. SQLite Android Database Cursor window allocation of 2048 kb failed
  10. Android SQLite: Update Statement
  11. How to delete SQLite database from Android programmatically
  12. How do I create a database in android? [closed]
  13. Android SimpleCursorAdapter doesn’t update when database changes
  14. How to implement Export sqlite To excel/csv file in android?
  15. How to store and retrieve a byte array (image data) to and from a SQLite database?
  16. SQLite Query in Android to count rows
  17. select distinct value in android sqlite
  18. App Crashes On Startup Due To java.lang.IllegalArgumentException: column ‘_id’ does not exist
  19. A pre-populated database does not work at API 28 throws “no such table” exception
  20. How does one check if a table exists in an Android SQLite database?
  21. Attempt to reopen an already-closed object sqlitedatabase
  22. Could not allocate CursorWindow
  23. how to save image taken from camera and show it to listview – crashes with “IllegalStateException”
  24. How insert image in room persistence library?
  25. When should I do certain SQLite operations on another thread(not the main thread)?
  26. How to view data saved in android database(SQLite)?
  27. Changing values from Cursor using SimpleCursorAdapter
  28. Compare dates (stored as string) in android sqlite database?
  29. H2 Database vs SQLite on Android [closed]
  30. Backup Room database

Leave a Comment