title: Android SimpleCursorAdapter doesn't update when database changes
body: <p>I have an Android <code>ListActivity</code> that is backed by a database <code>Cursor</code> through a <code>SimpleCursorAdapter</code>.</p>
  
  <p>When the items are clicked, a flag field in the coresponding row in the database is toggled and the view in the list needs to be updated.  </p>
  
  <p>The problem is, when the view that's updated goes off screen and is recycled, the old value is displayed on the view when it returns into view.  The same thing happens whenever thr list is redrawb (orientation changes, etc).  </p>
  
  <p>I use <code>notifydatasetchanged()</code> to refresh the cursor adapter but it seems ineffective.</p>
  
  <p>How should I be updating the database so the cursor is updated as well?</p>