Get row count from SQLite

Question

I am trying to get a row count from sqlite for my android application but for some reason its always returning Zero even though I have a enough amount of rows in my DB.

Here is the Code:

DatabaseConnector database1 = new DatabaseConnector(getApplicationContext());
int TotalPosts = database1.getIds();


 public int getIds()
       {
           String selectQuery = "SELECT COUNT(Pst_id) AS CountTotal FROM student_posts";           
           SQLiteDatabase database = this.dbOpenHelper.getReadableDatabase();
           Cursor c = database.rawQuery(selectQuery, null);     
           count = c.getColumnIndex("CountTotal");    
           return count;
       }

Thanks.

As @brianestey says, getColumnIndex returns the position of the column in the returned data set and NOT the value of what is in that column. In your case as you are only querying for a single value, i.e., COUNT you will only get one column and it's index will always be 0. — Squonk
– Squonk, Commented Jun 18, 2013 at 13:12

Community · Accepted Answer · 2014-06-27 14:12:32Z

10

Try like below:

public int getIds()
    {
    String selectQuery = "SELECT Pst_id FROM student_posts";           
    SQLiteDatabase database = this.dbOpenHelper.getReadableDatabase();
    Cursor c = database.rawQuery(selectQuery, null);
    c.moveToFirst();
    int total = c.getCount();
    c.close();

    return total;
}

edited Jun 27, 2014 at 14:12

CommunityBot

11 silver badge

answered Jun 18, 2013 at 13:08

Sagar Maiyad

12.7k9 gold badges66 silver badges102 bronze badges

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

2 Comments

Trojan Over a year ago

Thank you so much it worked :) just waiting for 6 more minutes to accept this answer :(

slott Over a year ago

Don't forget to close the cursor before returning!

Community · Accepted Answer · 2020-06-20 09:12:55Z

4

Try c.getCount()..

Reference

Hope this helps..

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jun 18, 2013 at 13:09

CRUSADER

5,4723 gold badges30 silver badges66 bronze badges

Collectives™ on Stack Overflow

Get row count from SQLite

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related