roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From snoopd...@apache.org
Subject svn commit: r314993 - /incubator/roller/branches/roller_2.0/src/org/roller/business/hibernate/HibernateRefererManagerImpl.java
Date Wed, 12 Oct 2005 18:47:55 GMT
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);



Mime
View raw message