upd: precise SQL statements for verification

[gigi.git] / src / club / wpia / gigi / dbObjects / Group.java

diff --git a/src/club/wpia/gigi/dbObjects/Group.java b/src/club/wpia/gigi/dbObjects/Group.java
index 778c46e014d1da29f246b9f57e831071b7255705..556395b294a7fb7735bbaaf0a438ee9177cef8be 100644 (file)
--- a/src/club/wpia/gigi/dbObjects/Group.java
+++ b/src/club/wpia/gigi/dbObjects/Group.java
@@ -74,7 +74,7 @@ public enum Group implements DBEnum {
     }
 
     public User[] getMembers(int offset, int count) {
     }
 
     public User[] getMembers(int offset, int count) {

-        try (GigiPreparedStatement gps = new GigiPreparedStatement("SELECT `user` FROM `user_groups` WHERE `permission`=?::`userGroup` AND `deleted` IS NULL OFFSET ? LIMIT ?", true)) {
+        try (GigiPreparedStatement gps = new GigiPreparedStatement("SELECT `user` FROM `user_groups` WHERE `permission`=?::`userGroup` AND `deleted` IS NULL OFFSET ?::INTEGER LIMIT ?::INTEGER", true)) {

             gps.setEnum(1, this);
             gps.setInt(2, offset);
             gps.setInt(3, count);
             gps.setEnum(1, this);
             gps.setInt(2, offset);
             gps.setInt(3, count);