X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=src%2Fclub%2Fwpia%2Fgigi%2FdbObjects%2FGroup.java;h=556395b294a7fb7735bbaaf0a438ee9177cef8be;hb=f8fd4a425309492e60c53133dc899ae3aa92914a;hp=778c46e014d1da29f246b9f57e831071b7255705;hpb=248c19aee75f896005872549b65f17701ded1fd2;p=gigi.git diff --git a/src/club/wpia/gigi/dbObjects/Group.java b/src/club/wpia/gigi/dbObjects/Group.java index 778c46e0..556395b2 100644 --- 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) { - 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);