Check to see if a value exists in DB

Question

I am trying to do a check if the User-name entered by the user exists in the DB.

public Cursor checkUsername(String username) throws SQLException {
    Cursor mCursor = db.query(true, TABLE_USERS, new String[] { ID,
            KEY_NAME, KEY_USERNAME}, KEY_USERNAME + "="
            + username, null, null, null, null, null);
    if (mCursor != null) {
        return true;
    }
    return false;
}

When i return true or false i am getting an Error saying

Type mismatch: cannot convert from boolean to Cursor

i just want to return true or false from the DBAdaptor back to the Activity.

Falmarri · Accepted Answer · 2010-12-26 06:31:33Z

4

Your function returns a Cursor

public Cursor checkUsername()

Either change it to return a boolean, or return a cursor.

answered Dec 26, 2010 at 6:31

Falmarri

48.7k43 gold badges158 silver badges196 bronze badges

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

3 Comments

Harsha M V Over a year ago

thanks for it :) i was checking in the Activity :) changed it to public Booleam :)

Falmarri Over a year ago

Sounds like your sql table doesn't have a column "harsha"

Harsha M V Over a year ago

but on the sql query its not asking for the column harsha either :(

John J Smith · Accepted Answer · 2010-12-26 12:18:31Z

0

Try reformatting your sql query and provide the 'where' clause as one of the parameters in the database call :

public Cursor getRoute(long rowIndex)
{
    String where = KEY_ID + "=" + rowIndex;
    return db.query(TBL_ROUTES, null, where, null, null, null, null);       
}

Also, remember to close your cursor when you are finished with it, otherwise you will get other exceptions.

answered Dec 26, 2010 at 12:18

John J Smith

12.1k9 gold badges57 silver badges75 bronze badges

Collectives™ on Stack Overflow

Check to see if a value exists in DB

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related