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; }