+/* NewsDatabaseHelper.java
+ *
+ * This program is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation, either version 3 of the License, or
+ * (at your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ * GNU General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with this program. If not, see <http://www.gnu.org/licenses/>.
+ */
package de.dhbwloe.campusapp.database;
import android.content.ContentValues;
public NewsItem[] getNewsItems(String source, long timeFrom, long timeTo) {
String[] whereArgs = new String[] {
source,
- Long.toString(timeFrom),
- Long.toString(timeTo)
+ Long.toString(timeTo),
+ Long.toString(timeFrom)
};
Cursor resultSet = database.rawQuery("SELECT Id, Source, Time, UniqueId, ChkSum, Title, Summary, Content, Link, Categories FROM News WHERE Source = ? AND Time >= ? AND Time <= ?", whereArgs);
ArrayList<NewsItem> results = new ArrayList<NewsItem>();