roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Guglielmo Carandente" <>
Subject There is a bug in getMostCommentedWeblogs method
Date Fri, 10 Oct 2008 10:34:53 GMT
In the method getMostCommentedWeblogs there is a bug because query retrieve
result with limit but don't order they first.

I think the solution is WeblogEntryComment.orm.xml file




            DISTINCT is not required for this query - comments would never
be duplicated in retrieved result

            because all the navigations from c are for ManyToOne


            <query>SELECT COUNT(c),,, FROM
WeblogEntryComment c WHERE c.weblogEntry.pubTime &lt; ?1 AND
c.weblogEntry.pubTime &gt; ?2 GROUP BY,, order by COUNT(c)




Do you think it's right?


Guglielmo Carandente
Junior Software Developer
cell: 3383567746



  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message