Read data from sqlite where column name contains spaces in android

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.

Answers


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.)


Need Your Help

What splitting criterion does Random Tree in Weka 3.7.11 use for numerical attributes?

machine-learning weka random-forest decision-tree

I'm using RandomForest from Weka 3.7.11 which in turn is bagging Weka's RandomTree. My input attributes are numerical and the output attribute(label) is also numerical.

to display calendar using javascript and php

php javascript

im new to this PHP im trying to develop a code such that when i click launch calendar it ll display calendar and when i choose the date it ll display in the text field but my problem is when i clik