sqlite query runtime error

Question

I was working with sqlite but I end up with this error.I'm not getting what is error here.

Below is my logcat.

android.database.sqlite.SQLiteException: near "/": syntax error: , while compiling: 

SELECT start,end FROM crop_list WHERE name =/sdcard/Shri Ramachandra kripalu bhajamana.mp3

Probably add quotes around the value of `name` in your query. — Aziz Shaikh, Apr 23 '12 at 11:11
Use prepared statements instead of manually creating (incorrect) SQL statements: http://stackoverflow.com/questions/433392/how-do-i-use-prepared-statements-in-sqlite-in-android — Philipp Reichart, Apr 23 '12 at 11:17

score 2 · Accepted Answer · answered Apr 23 '12 at 11:14

2

I think your problem is you forget to add the quotes marks (' ') like:

SELECT start,end FROM crop_list WHERE name ='/sdcard/Shri Ramachandra kripalu bhajamana.mp3'.

answered Apr 23 '12 at 11:14

gutiory

1,135
5
13
33

score 0 · Answer 2 · answered Apr 23 '12 at 14:42

0

why do you not use class helper and Helper.dabase.query(.....) <- it is faster ;) around 2 segons faster that helper.dabase.rawquery ;) SQLiteOpenHelper | Android Developers <-- best practice

answered Apr 23 '12 at 14:42

Alex Muni

473
5
16

sqlite query runtime error

2 Answers2