I'm Using Roller 4.0 with MySql 5.0. I call this method without modification, how in explained in roller themes guide. I think there isn't order by in this query in file WeblogEntryComment.orm.xml
SELECT COUNT(c), c.weblogEntry.website.id, c.weblogEntry.website.handle, c.weblogEntry.website.name FROM WeblogEntryComment c WHERE c.weblogEntry.pubTime < ?1 AND c.weblogEntry.pubTime > ?2 GROUP BY c.weblogEntry.website.id, c.weblogEntry.website.handle, c.weblogEntry.website.name order by c.id But changes don't work. I try many changes but nothing.... -----Messaggio originale----- Da: Anil Gangolli [mailto:[EMAIL PROTECTED] Inviato: mercoledì 29 ottobre 2008 17.04 A: [email protected] Oggetto: Re: getMostCommentedWeblogs Can you please provide more details? Which Roller version are you using? Have you made any of your own modifications to the code for this call? Which JDBC driver are you using? What database type and version are you using? --a. Guglielmo Carandente wrote: > I have problem with getMostCommentedWeblogs, in your blog it works fine? My > lyst is not ordered and there isn't most commented. > Someone can help me? > > > Guglielmo Carandente > Junior Software Developer > cell: 3383567746 > mail: [EMAIL PROTECTED] > www.cnmedia.it > > > > >
