How to make a select query using a local variable in SQLite on Android?

Question

I am new to sqlite and android, my question is simple, in visual studio if you want to make a query from local variable it is done by "'localvariable'" like wise but how on sqlite is possible?

for eg..

String local;
local = column1;

sqlite query

SELECT "'local'" FROM table

Table structure

table: column1 column2

in the above i cannot use the assigned local variable? what would be the syntax i am not able to figure out. i use raw query.

any help is highly appreciated

Yaqub Ahmad · Accepted Answer · 2012-09-18 07:27:59Z

2

String column1 = "NameOfMyFirstColumn";
String column2 = "NameOfMySecondColumn";
String sql = "SELECT "+ column1 +","+ column2 +" FROM table";
Cursor c = db.rawQuery(sql, null);

answered Sep 18, 2012 at 7:27

Yaqub Ahmad

27.7k24 gold badges105 silver badges151 bronze badges

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

Comments

Aprian · Accepted Answer · 2012-09-18 07:34:26Z

0

try this

Cursor cursor = db.rawQuery("SELECT ? FROM table", new String[] { local });

? will be replaced by local.

edited Sep 18, 2012 at 7:34

answered Sep 18, 2012 at 7:21

Aprian

1,7281 gold badge14 silver badges26 bronze badges

Collectives™ on Stack Overflow

How to make a select query using a local variable in SQLite on Android?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related