title: Pointing second cursor to same database in sqlite on android, this a no no?
body: <p>I have this function that is filling out a class based on data from several tables.  I got the first cursor:</p>
  
  <pre><code>String query="SELECT * FROM SESSION where _id =" + mSessionID + ";";
  Cursor c = dbAdapter.selectRecordsFromDB(query, null);
  Session session=null;
  c.moveToFirst();            
  </code></pre>
  
  <p>This works great.  Then  a little lower I do this:</p>
  
  <pre><code>long galleryId = c.getInt(4);               
  long packageId = c.getInt(5);
  long contractId = c.getInt(6);
  
  String query2="SELECT * FROM PHOTOPACKAGES WHERE _id =" + packageId + ";";
  Cursor p = dbAdapter.selectRecordsFromDB(query2, null);
  </code></pre>
  
  <p>and the p cursor always returns -1 for its count.  I can go right into the sqlite in the adb and run the same query where packageId = 1 and it works great...so not sure why this is not working, i don't see any other errors...can you just not use two cursors on the same database? p.s. selectRecordsFromDB is a helper function:</p>
  
  <pre><code>    public Cursor selectRecordsFromDB(String query, String[] selectionArgs) {
  
      Cursor c = myDataBase.rawQuery(query, selectionArgs);
      return myDataBase.rawQuery(query, selectionArgs);       
  }
  </code></pre>