Sqlite query returns no value Android

Question

I have a sql query that is not returning any value, but it has data to be returned. The following query code

Cursor cursor = db.query(CrimeDB.NOME_TABELA, CrimeDB.COLUNAS,
            CrimeDB.ID_CIDADE + "=" + idCidade + "" + " AND "
                    + CrimeDB.TIME + " >= datetime('" + dataInicioFormatada
                    + "') AND " + CrimeDB.TIME + " <= datetime('"
                    + dataFimFormatada + "')" + " AND "
                    + CrimeDB.GRUPO_CRIME + "=" + idCategoria + "", null,
            null, null, null);

Read cursor

if (cursor.moveToFirst()) {

        do {
            crime = new Crime();
            crime.setLastUpadateToken(ultimoTokenValido
                    .getUltimoTokenAtualizado());

            listCrime.add(itemCrime);

        } while (cursor.moveToNext());

    }

The query result is:

    SELECT    
        grupo_crime_id_grupo_crime, 
    id_crime, 
    cities_id_cities, 
    time 
FROM 
    crime 
WHERE 
    cities_id_cities=1650 AND 
    time >= datetime('20-10-2012') AND 
    time <= datetime('22-05-2014') AND 
    grupo_crime_id_grupo_crime=1

was returns to realize any value because there is value in the database. Using the SQLite Editor I see any register on the table crime.

id_crime | cities_id_cities | grupo_crime_id_grupo_crime | time
1          1650               1                            28-03-2013
2          1650               1                            06-04-2013

is your idCidade integer value ?

Chintan Soni
– Chintan Soni

2013-05-08 16:59:53 +00:00
Commented May 8, 2013 at 16:59 — Chintan Soni
– Chintan Soni, Commented May 8, 2013 at 16:59
Yes, I do. idCidade is integer value.

Douglas Mesquita
– Douglas Mesquita

2013-05-08 17:03:27 +00:00
Commented May 8, 2013 at 17:03 — Douglas Mesquita
– Douglas Mesquita, Commented May 8, 2013 at 17:03

Chintan Soni · Accepted Answer · 2013-05-08 17:07:12Z

1

Change the date format with yyyy/MM/dd and try using between instead of comparing dates with >= and <=.

answered May 8, 2013 at 17:07

Chintan Soni

25.4k26 gold badges113 silver badges177 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

stinepike · Accepted Answer · 2013-05-08 16:38:49Z

0

use apostrophe (') while checking in where clause

Cursor cursor = db.query(CrimeDB.NOME_TABELA, CrimeDB.COLUNAS,
            CrimeDB.ID_CIDADE + "='" + idCidade + "'" + " AND "
                    + CrimeDB.TIME + " >= datetime('" + dataInicioFormatada
                    + "') AND " + CrimeDB.TIME + " <= datetime('"
                    + dataFimFormatada + "')" + " AND "
                    + CrimeDB.GRUPO_CRIME + "='" + idCategoria + "'", null,
            null, null, null);

answered May 8, 2013 at 16:38

stinepike

54.9k14 gold badges95 silver badges116 bronze badges

1 Comment

Douglas Mesquita Over a year ago

tested that way and it made no difference :(

CL. · Accepted Answer · 2013-05-08 17:03:17Z

0

The proper date format, both in the database and in your query parameters, must be yyyy-mm-dd.

answered May 8, 2013 at 17:03

CL.

182k18 gold badges241 silver badges282 bronze badges

Collectives™ on Stack Overflow

Sqlite query returns no value Android

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related