New shows now list newest shows on top newlist
authorSebastian Brannstrom <sebastianb@symbian.org>
Mon, 15 Nov 2010 17:32:00 +0000
branchnewlist
changeset 351 a5e419ee2bb3
parent 350 9c4fd008e20f
child 352 31f9864a37ac
New shows now list newest shows on top
engine/src/ShowEngine.cpp
--- a/engine/src/ShowEngine.cpp	Mon Nov 15 17:25:39 2010 +0000
+++ b/engine/src/ShowEngine.cpp	Mon Nov 15 17:32:00 2010 +0000
@@ -712,7 +712,8 @@
 void CShowEngine::DBGetNewShowsL(RShowInfoArray& aShowArray)
 	{
 	DP("CShowEngine::DBGetNewShows");
-	_LIT(KSqlStatement, "select url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, uid, showsize, trackno, pubdate, showtype, lasterror, deletedate from shows where playstate=%u");
+	_LIT(KSqlStatement, "select url, title, description, filename, position, playtime, playstate, downloadstate, feeduid, uid, showsize, trackno, pubdate, showtype, lasterror from shows where playstate=%u order by pubdate desc");
+
 	iSqlBuffer.Format(KSqlStatement, ENeverPlayed);
 
 	sqlite3_stmt *st;