How do I construct this SQL query correctly

Question

I want to return the rows in my database that have the attribute in one of the fields equal to the parameter to the method. My code is:

    public Cursor fetchStatus(String status){
    Cursor mCursor =  

            mDb.query(DATABASE_TABLE, new String[] {KEY_COMPANY, KEY_POSITION, KEY_NOTES, KEY_WAGE, KEY_STATUS}, 
                    KEY_STATUS+ "= "+status, null, null, null, null)
            ;
    if(mCursor!=null) mCursor.moveToFirst();
    return mCursor;
}

I want to return the KEY_COMPANY, KEY_POSITION, KEY_NOTES, KEY_WAGE and KEY_STATUS columns where the KEY_STATUS is equal to the parameter 'status'

That is my code that I have tried, and it fails giving an error "SQLiteException near "for": syntax error: ..". The database is SQLite3, and my application is an android application — Shane
– Shane, Commented Oct 30, 2011 at 13:28
did you try rawQuery? mDb.rawQuery("sql statement", null); Your code seems to be correct. — abhinav
– abhinav, Commented Oct 30, 2011 at 13:33

Мitke · Accepted Answer · 2011-10-30 13:39:19Z

1

Perhaps you may try something like this:

public object GetValues (string status)
{
   string query = "SELECT KEY_COMPANY, KEY_POSITION, KEY_NOTES, KEY_WAGE,KEY_STATUS 
   FROM DATABASE_TABLE 
   WHERE KEY_STATUS = "'" +status+ "'" " ;

   dbcomands part...

   List<object> =  execute db comand....
}

The error you specified in your comment might be caused by the lack of ' ' in you query. Just a thought.

answered Oct 30, 2011 at 13:39

Мitke

3103 silver badges18 bronze badges

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

1 Comment

Shane Over a year ago

This worked, thank you. I was unaware that you needed to use single quotes like that

mishadoff · Accepted Answer · 2011-10-30 13:27:11Z

1

Use PreparedStatement.

You can simply specify your query and set parameters in search query.

answered Oct 30, 2011 at 13:27

mishadoff

10.8k2 gold badges36 silver badges55 bronze badges

Collectives™ on Stack Overflow

How do I construct this SQL query correctly

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related