svn commit: r569009 - /maven/archiva/branches/MRM-462/archiva-database/src/main/java/org/apache/maven/archiva/database/constraints/MostRecentRepositoryScanStatistics.java

[brett]

Author: brett
Date: Thu Aug 23 07:19:10 2007
New Revision: 569009

URL: http://svn.apache.org/viewvc?rev=569009&view=rev
Log:
[MRM-462] fix statistics query

Modified:
    
maven/archiva/branches/MRM-462/archiva-database/src/main/java/org/apache/maven/archiva/database/constraints/MostRecentRepositoryScanStatistics.java

Modified: 
maven/archiva/branches/MRM-462/archiva-database/src/main/java/org/apache/maven/archiva/database/constraints/MostRecentRepositoryScanStatistics.java
URL: 
http://svn.apache.org/viewvc/maven/archiva/branches/MRM-462/archiva-database/src/main/java/org/apache/maven/archiva/database/constraints/MostRecentRepositoryScanStatistics.java?rev=569009&r1=569008&r2=569009&view=diff
==============================================================================
--- 
maven/archiva/branches/MRM-462/archiva-database/src/main/java/org/apache/maven/archiva/database/constraints/MostRecentRepositoryScanStatistics.java
 (original)
+++ 
maven/archiva/branches/MRM-462/archiva-database/src/main/java/org/apache/maven/archiva/database/constraints/MostRecentRepositoryScanStatistics.java
 Thu Aug 23 07:19:10 2007
@@ -22,7 +22,7 @@
 import org.apache.maven.archiva.model.RepositoryContentStatistics;
 
 /**
- * MostRecentRepositoryScanStatistics 
+ * MostRecentRepositoryScanStatistics
  *
  * @author <a href="mailto:[EMAIL PROTECTED]">Joakim Erdfelt</a>
  * @version $Id$
@@ -34,12 +34,11 @@
 
     public MostRecentRepositoryScanStatistics( String repoId )
     {
-        sql = "SELECT FROM " + RepositoryContentStatistics.class.getName()
-            + " WHERE repositoryId == repoId PARAMETERS String repoId"
-            + " ORDER BY whenGathered DESCENDING"
-            + " RANGE 1,1";
+        sql = "SELECT FROM " + RepositoryContentStatistics.class.getName() +
+            " WHERE repositoryId == repoId PARAMETERS String repoId" + " ORDER 
BY whenGathered DESCENDING" +
+            " RANGE 0,1";
 
-        super.params = new Object[] { repoId };
+        super.params = new Object[]{repoId};
     }
 
     public Class getResultClass()