Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Read data from SQLite where column name contains spaces

I am having a coulmn name called "condition name" (.sql file has been generated from server)

But in android I am getting following exception while reading data from that table.

12-24 14:34:00.870: W/System.err(269): android.database.sqlite.SQLiteException: no such column: condition: ,

while compiling:

SELECT condition, category, subcategory,condition name, local path, remote path, title, content_type FROM library WHERE category = ?

Its not recognizing whole table name and breaking at space. if you have any ideas please assist me.

like image 789
Vijay YD Avatar asked Dec 24 '12 09:12

Vijay YD


2 Answers

And you put the table name outside the quote as in:

tableName."column name"

and not

"tableName.column name"

like image 53
Walker Rowe Avatar answered Sep 20 '22 09:09

Walker Rowe


For quoting identifiers like table/column names, SQLite supports back ticks for compatibility with MySQL, and square brackets for compatibility with SQL Server, but the portable way is to use double quotes:

SELECT "condition name" FROM library

(Single quotes would be used for string values.)

like image 31
CL. Avatar answered Sep 21 '22 09:09

CL.