Using the LIMIT statement in a SQLite query

Posted by anselmophil on Stack Overflow See other posts from Stack Overflow or by anselmophil
Published on 2010-03-23T04:58:49Z Indexed on 2010/03/23 5:01 UTC
Read the original article Hit count: 301

Hi guys.

I have a query that selects rows in a ListView without having a limit. But now that i have implemented a SharedPreferences that the user can select how much rows will be displayed in the ListView, my SQLite query doesnt work. Im passing the argument this way:

return wDb.query(TABELANOME, new String[] {IDTIT, TAREFATIT, SUMARIOTIT}, CONCLUIDOTIT + "=1", null, null, null, null, "LIMIT='" + limite + "'");

Help, please!

© Stack Overflow or respective owner

Related posts about android

Related posts about listview