Mercurial > avadmin > converted

changeset 449:d1e535b685db

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Order messages by date sent from the most recent (Logical change 1.130)
author optonline.net!jeffpc
date Sun, 28 Dec 2003 04:01:20 +0000
parents 9615efc39e6a
children 094b0be6a540
files mess_ls.py
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/mess_ls.py	Sun Dec 28 04:01:20 2003 +0000
+++ b/mess_ls.py	Sun Dec 28 04:01:20 2003 +0000
@@ -41,7 +41,7 @@
 if (av_message.totalMessages(conn)):
 	print "<table class=\"plain\">\n"
 	print "<tr><td class=\"main\"><b>From</b></td><td class=\"main\"><b>Subject</b></td><td class=\"main\"><b>Date Sent</b></td></tr>\n"
-	for messid in conn.db.execSQL("SELECT `id` FROM `messages` WHERE `touser` = " + str(conn.user.getUID()) + ";"):
+	for messid in conn.db.execSQL("SELECT `id` FROM `messages` WHERE `touser` = " + str(conn.user.getUID()) + " ORDER BY `datesent` DESC, `id` DESC;"):
 		mess = av_message.Message(conn,messid[0])
 		
 		# From