SQLite Exception no such column when trying to select

by

What’s happening here is that SQLite thinks that ‘pb3874’ is actually a column name, rather than a string/text literal.

To specify that it’s a text literal, you’ll want to ensure your text value is wrapped in the appropriate single quotes:

To prevent SQL injection attacks, whenever you’re taking input from the user, use a parameterized query:

("select count(*) from usertable where " + KEY_STUDID + "=?", studid);

Without parameterization (very much discouraged when taking user input):

("select count(*) from usertable where " + KEY_STUDID + "='" + studid + "'", null);

The reason your numeric values didn’t produce this: SQLite converted those numeric literals for you.

More Related Contents:

  1. Android SQLite data display to ListView
  2. IN clause and placeholders
  3. Android Database Transaction
  4. Best place to close database connection
  5. Backup and restore SQLite database to sdcard
  6. Permission Denial: this requires android.permission.INTERACT_ACROSS_USERS_FULL
  7. How to split comma-separated value in SQLite?
  8. Import .csv file to Sqlite in Android
  9. Cursor adapter and sqlite example [closed]
  10. How to insert a SQLite record with a datetime set to ‘now’ in Android application?
  11. How to retrieve data from sqlite database in android and display it in TextView
  12. Bulk Insertion on Android device
  13. Android Sqlite selection args[] with int values
  14. SQLite simultaneous reading and writing
  15. update sql database with ContentValues and the update-method
  16. SQLiteDatabase close() function causing NullPointerException when multiple threads
  17. Using the LIMIT statement in a SQLite query
  18. sqlite encryption for android
  19. Android quotes within an sql query string
  20. Android SQLite rawquery parameters
  21. Saving ArrayLists in SQLite databases
  22. How to access an existing sqlite database in Android?
  23. How to convert milliseconds to date in SQLite
  24. DB File in Assets Folder. Will it be Updated?
  25. Backup/restore sqlite db in android [duplicate]
  26. difference between rawquery and execSQL in android sqlite database
  27. how to drop database in sqlite?
  28. Get SQLite database from Android app
  29. Does Android SQLite cursor load all records into memory at once?
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment