Manipulating database output in Android strings
<p>I'm trying to manipulate the output of an SQLite query so into two parts - KEY_DATE and KEY_ROWID + KEY_TYPE.  Here's the code without the KEY_TYPE bit: </p>

<pre><code>    DataBaseAdapter db = new DataBaseAdapter(this);
    db.open();
    // get last test date
    int whichItem = 1;
    int upDown = 1; // use 1 for descending ordering
    Cursor mCursor = db.getLogType(whichItem, upDown);
    String[] columns = new String[] {DataBaseAdapter.KEY_DATE, DataBaseAdapter.KEY_ROWID};
    startManagingCursor(mCursor);
    ListAdapter adapter = new SimpleCursorAdapter(this, android.R.layout.simple_expandable_list_item_2, mCursor, columns, new int[] {android.R.id.text1, android.R.id.text2}){
        public boolean areAllItemsEnabled(){ 
            return false; 
        } 
        public boolean isEnabled(int position){ 
            return false; 
        }
    };
    setListAdapter(adapter);
    db.close();
</code></pre>

<p>It works fine, but when I replace:</p>

<pre><code>    String[] columns = new String[] {DataBaseAdapter.KEY_DATE, DataBaseAdapter.KEY_ROWID};
</code></pre>

<p>with:</p>

<pre><code>    String[] columns = new String[] {DataBaseAdapter.KEY_DATE, DataBaseAdapter.KEY_ROWID + DataBaseAdapter.KEY_TYPE};
</code></pre>

<p>it doesn't work.</p>

<p>All help much appreciated!</p>
