You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@roller.apache.org by sn...@apache.org on 2006/07/31 23:56:40 UTC

svn commit: r427315 - /incubator/roller/branches/roller_3.0/src/org/apache/roller/business/hibernate/HibernateRefererManagerImpl.java

Author: snoopdave
Date: Mon Jul 31 14:56:39 2006
New Revision: 427315

URL: http://svn.apache.org/viewvc?rev=427315&view=rev
Log:
Fixing SQL syntax error in hot blogs query

Modified:
    incubator/roller/branches/roller_3.0/src/org/apache/roller/business/hibernate/HibernateRefererManagerImpl.java

Modified: incubator/roller/branches/roller_3.0/src/org/apache/roller/business/hibernate/HibernateRefererManagerImpl.java
URL: http://svn.apache.org/viewvc/incubator/roller/branches/roller_3.0/src/org/apache/roller/business/hibernate/HibernateRefererManagerImpl.java?rev=427315&r1=427314&r2=427315&view=diff
==============================================================================
--- incubator/roller/branches/roller_3.0/src/org/apache/roller/business/hibernate/HibernateRefererManagerImpl.java (original)
+++ incubator/roller/branches/roller_3.0/src/org/apache/roller/business/hibernate/HibernateRefererManagerImpl.java Mon Jul 31 14:56:39 2006
@@ -277,7 +277,7 @@
             Query query = session.createQuery(
                 "select sum(r.dayHits) as s, w.id, w.name, w.handle  "
                +"from WebsiteData w, RefererData r "
-               +"where r.website=w and w.enabled=true and w.active=true and w.lastModified > :startDate"
+               +"where r.website=w and w.enabled=true and w.active=true and w.lastModified > :startDate "
                +"group by w.name, w.handle, w.id order by col_0_0_ desc"); 
             query.setParameter("startDate", startDate);