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
– Aziz Shaikh, Commented Apr 23, 2012 at 11:11
Use prepared statements instead of manually creating (incorrect) SQL statements: stackoverflow.com/questions/433392/… — Philipp Reichart
– Philipp Reichart, Commented Apr 23, 2012 at 11:17

gutiory · Accepted Answer · 2012-04-23 11:14:30Z

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, 2012 at 11:14

gutiory

1,1355 gold badges13 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alex Muni · Accepted Answer · 2012-04-23 14:42:58Z

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, 2012 at 14:42

Alex Muni

4745 silver badges16 bronze badges

Collectives™ on Stack Overflow

sqlite query runtime error

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related