From 9fb3c531c2f75842dd2e9a3aea34084e2e7988bd Mon Sep 17 00:00:00 2001
From: sostler <sbostler@gmail.com>
Date: Sun, 3 Jan 2010 21:01:05 -0500
Subject: room log fix

---
 src/site.clj | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/site.clj')

diff --git a/src/site.clj b/src/site.clj
index a450377..e57580a 100755
--- a/src/site.clj
+++ b/src/site.clj
@@ -139,7 +139,7 @@
   (if s (Integer/parseInt s) f))
 
 (defn count-messages-by-room [room-id image-only]
-  (let [query (str "SELECT m.content, m.created_on, u.nick "
+  (let [query (str "SELECT COUNT(*) "
 		   "FROM messages m, users u "
 		   "WHERE room_id = ? AND m.user_id = u.user_id "
 		   (if image-only "AND m.is_image = true " ""))]
-- 
cgit v1.2.3-70-g09d2