Android SQL query problem

Question

I'm hitting a wall in an android SQL query, this is what I have so far:

        mDb.query(false, DATABASE_TABLE, new String[] {KEY_ROWID, KEY_ROWONE, KEY_ROWTWO, KEY_ROWTHREE, KEY_ROWFOUR, KEY_ROWFIVE}, KEY_ROWONE +" LIKE '?%'", new String[] { letter }, null, null, null, null);

Basically, I want the query to return all the rows in the table where KEY_ROWONE starts with the variable letter (a string containing one letter).

I get a force close when I'm running the code, and I'm really puzzled.

I promise to tick the best answer!

Todd Davies · Accepted Answer · 2011-02-23 08:31:20Z

1

It's alright guys, panic over, I found the solution:

mDb.query(true, DATABASE_TABLE, new String[] {KEY_ROWID, KEY_ROWONE, KEY_ROWTWO, KEY_ROWTHREE, KEY_ROWFOUR, KEY_ROWFIVE}, KEY_ROWONE+" LIKE ? || '%'", new String[] { l }, null, null, null, null);

answered Feb 23, 2011 at 8:31

Todd Davies

5,5328 gold badges49 silver badges73 bronze badges

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

Comments

Vivienne Fosh · Accepted Answer · 2011-02-23 09:50:42Z

0

Just in case someone will be interested, here's full database tutorial for android: http://knightswhocode.com/wordpress/?p=14

answered Feb 23, 2011 at 9:50

Vivienne Fosh

1,78817 silver badges24 bronze badges

Collectives™ on Stack Overflow

Android SQL query problem

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