SQLite get value from DB

Question

I am trying to make query from DB in the following way

public Cursor getManagementData() { String selectQuery = "SELECT * FROM " + DBHelper.TABLE_STAFF + " WHERE " + DBHelper.COLUMN_DEPARTMENT + " GLOB " + "'management'"; return db.rawQuery(selectQuery, null); }

The same thing I have tried with

query(DBHelper.TABLE_STAFF, new String[] { DBHelper.COLUMN_ID, DBHelper.COLUMN_NAME, DBHelper.COLUMN_LAST_NAME, DBHelper.COLUMN_POSITION, DBHelper.COLUMN_DEPARTMENT, DBHelper.COLUMN_PICTURE }, null, new String[] { "management" }, null, null, null);

but nothing happens.

The table structure is very simple: Table staff with Column department and I want to get all entries named management.

If you will not be able to answer, please recommend where to find close solution because after googling I have not found any comprehensive examples on searching DB by entries whether with rawQuery or just query.

Thank you in advance.

I have made changes recomended by Mr.Choy it does not crashes but when open in my app list is empty. At the same time when I run the following query:

 public Cursor getEmployeesData() { return db.query(DBHelper.TABLE_STAFF, new String[] { DBHelper.COLUMN_ID, DBHelper.COLUMN_NAME, DBHelper.COLUMN_LAST_NAME, DBHelper.COLUMN_POSITION, DBHelper.COLUMN_DEPARTMENT, DBHelper.COLUMN_PICTURE }, null, null, null, null, null); }

it shows all data as it should be.

Could it be the problem with cursor adapter def. I use:

 String[] from = new String[] { DBHelper.COLUMN_NAME, DBHelper.COLUMN_LAST_NAME, DBHelper.COLUMN_POSITION, DBHelper.COLUMN_DEPARTMENT, DBHelper.COLUMN_PICTURE }; int[] to = new int[] { R.id.textView1, R.id.textView2, R.id.textView3, R.id.textView4, R.id.imageView1 };

it says syntax error. What about just query. What am I doing wrong. And do you know any sites where I can find comprehensive info on query use. — user1706819
– user1706819, Commented Nov 22, 2013 at 8:08

Lawrence Choy · Accepted Answer · 2013-11-22 08:21:58Z

1

I think your raw query is wrong. It should be

String selectQuery = "SELECT * FROM " + DBHelper.TABLE_STAFF + " WHERE " + DBHelper.COLUMN_DEPARTMENT + "='management'";

You can take a look at basic SQL query syntax here

edited Nov 22, 2013 at 8:21

answered Nov 22, 2013 at 8:01

Lawrence Choy

6,1081 gold badge22 silver badges30 bronze badges

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

6 Comments

Lawrence Choy Over a year ago

@user1706819 What is the value of DBHelper.COLUMN_DEPARTMENT?

Lawrence Choy Over a year ago

@user1706819 Are you sure the value is management? It defines a table column name which should be something like department. I suspect it is causing error in the SQL, thats why I am asking it's value.

user1706819 Over a year ago

public static final String COLUMN_DEPARTMENT = "department";

user1706819 Over a year ago

sorry, I did not get your question. I thought you are asking about value to be retireved.

Lawrence Choy Over a year ago

@user1706819 Then the query should be fine. You can take a look at the link I provided in the answer, hope that helps you solve the problem!

|

Shayan Pourvatan · Accepted Answer · 2013-11-22 08:26:18Z

I think you forgot equal statement in your function use this:

 String selectQuery = "SELECT * FROM " + DBHelper.TABLE_STAFF + " WHERE " + DBHelper.COLUMN_DEPARTMENT + "='management'";

DBHelper.COLUMN_DEPARTMENT must be your colomn name and management must be the value in colomn that you want

you can read this Article and this for more information of basic SQL query

I saw Vogel's example and find his resource as very valuable for new developers like me. But he does'not provide any examples on quering by values

Collectives™ on Stack Overflow

SQLite get value from DB

2 Answers 2

6 Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Related