change sql LIMIT usage from LIMIT #,# to LIMIT # OFFSET #, this is makes us postgresq...

diff --git a/source/mir/storage/Database.java b/source/mir/storage/Database.java
index 20bd66d..4af1769 100755 (executable)
--- a/source/mir/storage/Database.java
+++ b/source/mir/storage/Database.java
@@ -56,7 +56,7 @@ import  mir.util.*;
  * Treiber, Host, User und Passwort, ueber den der Zugriff auf die\r
  * Datenbank erfolgt.\r
  *\r
- * @version $Id: Database.java,v 1.29 2002/12/23 03:18:02 mh Exp $\r
+ * @version $Id: Database.java,v 1.30 2002/12/28 03:21:38 mh Exp $\r
  * @author rk\r
  *\r
  */\r
@@ -504,13 +504,7 @@ public class Database implements StorageObject {
     }\r
     if (theAdaptor.hasLimit()) {\r
       if (limit > -1 && offset > -1) {\r
-        selectSql.append(" limit ");\r
-        if (theAdaptor.reverseLimit()) {\r
-          selectSql.append(limit).append(",").append(offset);\r
-        }\r
-        else {\r
-          selectSql.append(offset).append(",").append(limit);\r
-        }\r
+        selectSql.append(" LIMIT ").append(limit).append(" OFFSET ").append(offset);\r
       }\r
     }\r
 \r