Android SQLite rawquery parameters

by

All parameter places should be designated with ?. The parameters to the query are always string nontheless, so nothing special about the integers. This should work for you:

Cursor cur3 = database2.rawQuery("select max(UnixTimeStamp) from Quote where EmoticonID=? and SubCategoryID=?" ,new String [] {String.valueOf(g),String.valueOf(s)});

More Related Contents:

  1. Android SQLite data display to ListView
  2. How to retrieve and display data from a database to TextView
  3. IN clause and placeholders
  4. Android Database Transaction
  5. Best place to close database connection
  6. Backup and restore SQLite database to sdcard
  7. Permission Denial: this requires android.permission.INTERACT_ACROSS_USERS_FULL
  8. How to split comma-separated value in SQLite?
  9. Debugging sqlite database on the device
  10. Cursor adapter and sqlite example [closed]
  11. How to insert a SQLite record with a datetime set to ‘now’ in Android application?
  12. How to retrieve data from sqlite database in android and display it in TextView
  13. Android: column ‘_id’ does not exist
  14. Android Save images to SQLite or SDCard or memory
  15. Android Cursor with ORMLite to use in CursorAdapter
  16. SQLite simultaneous reading and writing
  17. Is it possible to apply primary key on the text fields in android database
  18. SQLiteDatabase close() function causing NullPointerException when multiple threads
  19. How to store sqlite database directly on sdcard
  20. sqlite example program in android [closed]
  21. Create SQLite database in android
  22. Saving ArrayLists in SQLite databases
  23. How to access an existing sqlite database in Android?
  24. How to convert milliseconds to date in SQLite
  25. Backup/restore sqlite db in android [duplicate]
  26. How to store JSON object in SQLite database
  27. sqlite3: not found
  28. Android SQLiteOpenHelper cannot open database file
  29. Getting the type of a column in SQLite
  30. Android table creation Failure (near “autoincrement”: syntax error)?

Leave a Comment