Android: replace values of a cursor/sql query

In my SQL database table there are colums _id, int dayofweek, String text ... I now, do a SQL query on that table to get a cursor to the results. The results then are shown in 开发者_开发知识库a listView:

private void showBlocks()
{
    Cursor blocks = ttDB.getBlocks();
    startManagingCursor(blocks);

    int[] key = new int []{
            android.R.id.text1,
            android.R.id.text2 
    };

    SimpleCursorAdapter blockAdapter = new SimpleCursorAdapter(
            this, 
            android.R.layout.simple_list_item_2,
            blocks, 
            new String[] {
                    "day",
                    "text"
                }, 
            key);

    lv1.setAdapter(blockAdapter);
 }

How (and where) can I now replace the integer values of dayofweek by the corresponding strings? I thought about joining two tables while querying but then it will not be multilingual any more.

You can try using a ViewBinder via setViewBinder() on your SimpleCursorAdapter.

Or, extend SimpleCursorAdapter, override bindView() and do it yourself.

you can not directly replace values .you have to store first it in list and than you can replace it with ur desired fromat