android : SQL Exception while querying

Question

Team,

Can you please help me to understand why I m getting the following exception.

05-07 10:57:20.652: ERROR/AndroidRuntime(470): android.database.sqlite.SQLiteException: near "1": syntax error: , while compiling: SELECT Id,Name FROM act WHERE Id 1-IJUS-1

Thanks in advance,

can you please copy and paste the code you are using, i didnt get any information from the error statement. — Vamsi
– Vamsi, Commented May 7, 2010 at 6:11

CommonsWare · Accepted Answer · 2010-05-07 11:44:23Z

1

Your SQL is invalid. You may be missing an equals sign and some quotation marks around the value:

SELECT Id,Name FROM act WHERE Id="1-IJUS-1"

However, without knowing your table structure, it is difficult to know for certain. The SQLite documenation is freely available online for more on how to construct a SQL query.

answered May 7, 2010 at 11:44

CommonsWare

1.0m195 gold badges2.4k silver badges2.7k bronze badges

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

Collectives™ on Stack Overflow

android : SQL Exception while querying

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related