Guest User

Untitled

a guest
Jul 17th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. public void whosnext(View view) {
  2. // || is the concatenation operation in SQLite
  3. cursor = db.rawQuery("SELECT * FROM eventsv1 WHERE start_time > (DATETIME('now','+1 hour')) AND title LIKE ? ORDER BY date ASC, time DESC",
  4. new String[]{"%" + searchText.getText().toString() + "%"});
  5. adapter = new SimpleCursorAdapter(
  6. this,
  7. R.layout.artist_list_item,
  8. cursor,
  9. new String[] {"title", "time", "date", "title3", "style"},
  10. new int[] {R.id.title, R.id.time, R.id.date, R.id.title3, R.id.style});
  11. setListAdapter(adapter);
  12. }
Add Comment
Please, Sign In to add comment