Android quotes within an sql query string

by

You should make use of the rawQuery method’s selectionArgs parameter:

p_query = "select * from mytable where name_field = ?";
mDb.rawQuery(p_query, new String[] { uvalue });

This not only solves your quotes problem but also mitigates SQL Injection.

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. How do I join two SQLite tables in my Android application?
  7. How can I create a user-defined function in SQLite?
  8. SQLite Android Database Cursor window allocation of 2048 kb failed
  9. Android SQLite: Update Statement
  10. How to delete SQLite database from Android programmatically
  11. Android error – close() was never explicitly called on database
  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. problem about sqlite database, no such table:
  17. SQLite Query in Android to count rows
  18. Using the LIMIT statement in a SQLite query
  19. sqlite encryption for android
  20. Attempt to reopen an already-closed object sqlitedatabase
  21. how to save image taken from camera and show it to listview – crashes with “IllegalStateException”
  22. How insert image in room persistence library?
  23. How to view data saved in android database(SQLite)?
  24. SQLite android column not found
  25. SQlite – Android – Foreign key syntax
  26. Inserting values to SQLite table in Android
  27. Queries with prepared statements in Android?
  28. SQLiteOpenHelper onUpgrade() Confusion Android
  29. Using COLLATE in Android SQLite – Locales is ignored in LIKE statement
  30. SQLite Foreign Key

Leave a Comment