From 8d6656f01e08a70c083de62902f490c60fb5bedc Mon Sep 17 00:00:00 2001 From: =?utf8?q?Felix=20D=C3=B6rre?= Date: Sat, 26 Mar 2016 19:22:13 +0100 Subject: [PATCH] fix: postgres-boolean are t/f --- src/org/cacert/gigi/dbObjects/CertificateOwner.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/org/cacert/gigi/dbObjects/CertificateOwner.java b/src/org/cacert/gigi/dbObjects/CertificateOwner.java index 8ba04fee..3ca821f3 100644 --- a/src/org/cacert/gigi/dbObjects/CertificateOwner.java +++ b/src/org/cacert/gigi/dbObjects/CertificateOwner.java @@ -116,7 +116,7 @@ public abstract class CertificateOwner implements IdCachable { } public static CertificateOwner getByEnabledSerial(String serial) { - try (GigiPreparedStatement prep = new GigiPreparedStatement("SELECT `memid` FROM `certs` WHERE serial=? AND `disablelogin`='0' AND `revoked` is NULL")) { + try (GigiPreparedStatement prep = new GigiPreparedStatement("SELECT `memid` FROM `certs` WHERE serial=? AND `disablelogin`='f' AND `revoked` is NULL")) { prep.setString(1, serial.toLowerCase()); GigiResultSet res = prep.executeQuery(); if (res.next()) { -- 2.39.2