X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Fclub%2Fwpia%2Fgigi%2FdbObjects%2FGroup.java;h=556395b294a7fb7735bbaaf0a438ee9177cef8be;hp=778c46e014d1da29f246b9f57e831071b7255705;hb=0d5ae34e23b50f59e759702b1ebf6f5a3a7137f4;hpb=a1fb2906862d4edc566a49d5a6c9133cffcfba68 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);