mardi 6 octobre 2015

sqlite table initialized in an incorrect way through xml file in android

I have the following xml table

<?xml version="1.0" encoding="utf-8"?>

<string-array name="my_array">

    <item>rome 999 3 4 5 7 9 11 17</item>

</string-array>

which I use in android to initialize a table in the way:

    public static abstract class FeedEntry implements BaseColumns {
    public static final String TABLE_NAME = "entry";
    public static final String COLUMN_NAME_ENTRY_ID = "entryid";
    public static final String COLUMN_NAME_TITLE = "title";
    public static final String COLUMN_NAME_SCHEDULE = "schedule";
}

but when I make an sqlite request on it like:

        Cursor cursor = db.query(
            FeedReaderContract.FeedEntry.TABLE_NAME,  // The table to query
            projection,                               // The columns to return
            FeedReaderContract.FeedEntry.COLUMN_NAME_TITLE+" = " + string ,                                // The columns for the WHERE clause
            null,                            // The values for the WHERE clause
            null,                                     // don't group the rows
            null,                                    // don't filter by row groups
            sortOrder                                 // The sort order
    );
    DatabaseUtils.dumpCursor(cursor);

the result of the dumpCursor is :

I/System.out: 0 {
I/System.out:    title=999
I/System.out:    schedule=34 5 7 9 11 17 
I/System.out: }

Basically, I don't store the correct values. How to fix it?

Aucun commentaire:

Enregistrer un commentaire