diff options
| author | sostler <sbostler@gmail.com> | 2010-01-03 21:01:05 -0500 |
|---|---|---|
| committer | sostler <sbostler@gmail.com> | 2010-01-03 21:01:05 -0500 |
| commit | 9fb3c531c2f75842dd2e9a3aea34084e2e7988bd (patch) | |
| tree | 1bc262c78b54ad8cd6e95604e767cd5b875f4589 /src/site.clj | |
| parent | ade9cf4fdd64d84a8694e03866acf9be8fe2ed83 (diff) | |
room log fix
Diffstat (limited to 'src/site.clj')
| -rwxr-xr-x | src/site.clj | 2 |
1 files changed, 1 insertions, 1 deletions
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 " ""))] |
