Public feed #890657

Stuff

public text v1 · immutable
Raw Edit
·published 2008-02-03 22:49 UTC
rendered paste body
bool HistoryDatabase::queryVisitedDays()
{
    ASSERT_ICON_SYNC_THREAD();
    
    SQLiteStatement query(m_syncDB, "SELECT datetime('2006-02-05 20:09:23','group days by 1');");
    query.prepare();

    int result = query.step();
    while (result == SQLResultRow) {

        String visited = query.getColumnText(0);
        g_print("Visited on %s\n", visited);
        result = query.step();
    }
    if (result != SQLResultDone)
         g_error("\nFailed to query for visited days: %s", m_syncDB.lastErrorMsg());
    
    query.reset();
    return false;
}