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 2005/10/12 20:47:55 UTC
svn commit: r314993 -
/incubator/roller/branches/roller_2.0/src/org/roller/business/hibernate/HibernateRefererManagerImpl.java
Author: snoopdave
Date: Wed Oct 12 11:47:53 2005
New Revision: 314993
URL: http://svn.apache.org/viewcvs?rev=314993&view=rev
Log:
Bug in HSQLDB specific query string
Modified:
incubator/roller/branches/roller_2.0/src/org/roller/business/hibernate/HibernateRefererManagerImpl.java
Modified: incubator/roller/branches/roller_2.0/src/org/roller/business/hibernate/HibernateRefererManagerImpl.java
URL: http://svn.apache.org/viewcvs/incubator/roller/branches/roller_2.0/src/org/roller/business/hibernate/HibernateRefererManagerImpl.java?rev=314993&r1=314992&r2=314993&view=diff
==============================================================================
--- incubator/roller/branches/roller_2.0/src/org/roller/business/hibernate/HibernateRefererManagerImpl.java (original)
+++ incubator/roller/branches/roller_2.0/src/org/roller/business/hibernate/HibernateRefererManagerImpl.java Wed Oct 12 11:47:53 2005
@@ -183,7 +183,7 @@
stmt = con.prepareStatement(
"select top ? w.id,w.name,w.handle,sum(r.dayhits) as s "+
"from website as w, referer as r "+
- "where r.websiteid=w.id and and w.isenabled=? " +
+ "where r.websiteid=w.id and w.isenabled=? " +
"group by w.name,w.handle,w.id order by s desc");
stmt.setInt(1, max);
stmt.setBoolean(2, true);