SQLiteException when executing query

Question

I want to execute a ManagedQuery but am getting a error in my log:

Query

 Cursor cursor = managedQuery(GroceryListContentProvider.NOTES_URI,projection,Notes.NOTE_TITLE+"="+S+" AND "+ Notes.NOTE_DATE+"="+S1, null, null);

Error Log

02-21 16:00:52.395: E/AndroidRuntime(22534): java.lang.RuntimeException: Unable to start activity ComponentInfo{net.schuemie.GroceryList/net.schuemie.GroceryList.shoppinglist}: android.database.sqlite.SQLiteException: near "new": syntax error: , while compiling: SELECT item_name FROM notes WHERE (title=shop new AND date=12/2/12) ORDER BY title

It's not a compilation error, it's a runtime error, hence RuntimeException ;-) — James Goodwin
– James Goodwin, Commented Feb 21, 2012 at 11:01

Nataliia.dev · Accepted Answer · 2012-02-21 11:03:03Z

1

remove "new" from query and add quotes to string values

SELECT item_name FROM notes WHERE (title='shop' AND date=12/2/12) ORDER BY title

answered Feb 21, 2012 at 11:03

Nataliia.dev

2,9724 gold badges42 silver badges54 bronze badges

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

1 Comment

Nataliia.dev Over a year ago

SELECT item_name FROM notes WHERE (title=shop new AND date=12/2/12) ORDER BY title - this is your query from error log. look carefully, new can be in title field value, so your query must look loke this SELECT item_name FROM notes WHERE (title='shop new' AND date=12/2/12) ORDER BY title

Sumant · Accepted Answer · 2012-02-21 12:16:32Z

0

Update

String where = "title='"+nameOfTitle+"' And date="+date+" "; 


Cursor cursor = managedQuery(GroceryListContentProvider.NOTES_URI,null,where,null,null);

edited Feb 21, 2012 at 12:16

answered Feb 21, 2012 at 11:07

Sumant

2,8052 gold badges24 silver badges30 bronze badges

9 Comments

remss Over a year ago

using this query i printed in log cat to see hw many rows its returning but it is showing as zero.............bt when i keep the where clause part as null it will print in the log that there are four rows..........y do i have this error??

Sumant Over a year ago

can u post that both query which u r printing in your logcat

remss Over a year ago

Cursor cursor = managedQuery(GroceryListContentProvider.NOTES_URI,null,Notes.NOTE_TITLE+"='"+S+"' AND "+ Notes.NOTE_DATE+"="+S1, null, null);when i use this it returns zero rows

remss Over a year ago

Cursor cursor = managedQuery(GroceryListContentProvider.NOTES_URI,null,null, null, null);when i use this it returns four rows which are present in the database

remss Over a year ago

is there anyone who could give a solution for this??

|

Joand · Accepted Answer · 2012-02-21 11:03:38Z

0

Did you try to do this

title="shop"

or

title='shop'

answered Feb 21, 2012 at 11:03

Joand

3524 silver badges14 bronze badges

1 Comment

remss Over a year ago

S is currently my title and checking it with my column name in my database

Collectives™ on Stack Overflow

SQLiteException when executing query

3 Answers 3

1 Comment

9 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

9 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related