X-Git-Url: https://harishankar.org/repos/?p=habeas.git;a=blobdiff_plain;f=src%2Fhabeas%2FUtility.java;h=0e6d9ebdb70a4b189f82d54fbb28c1e733f1efa8;hp=aac247c9a3d9fcde388e854c06adbfc72d058015;hb=67bb9fdd9ae3818a92a528d14d82baae0d483508;hpb=5b12182f8ba1ad6811d37ba582095b45a34fde2f

diff --git a/src/habeas/Utility.java b/src/habeas/Utility.java
index aac247c..0e6d9eb 100644
--- a/src/habeas/Utility.java
+++ b/src/habeas/Utility.java
@@ -175,7 +175,9 @@ public class Utility {
         ArrayList<Object> notice = new ArrayList<>();
         try {
             Connection conn = DriverManager.getConnection(JDBC + connectionURL);
-            PreparedStatement st = conn.prepareStatement("SELECT * FROM legalnotices WHERE id=?;");
+            PreparedStatement st = conn.prepareStatement("SELECT legalnotices.*, clients.ClientName "
+                    + "FROM legalnotices "
+                    + "INNER JOIN clients WHERE ClientId=clients.id AND legalnotices.id=?;");
             st.setInt(1, selid);
             ResultSet rs = st.executeQuery();
             while (rs.next()) {
@@ -195,6 +197,7 @@ public class Utility {
                 notice.add (getValidDate (rs, "BillDate"));
                 notice.add (rs.getBoolean ("ClarificationPending"));
                 notice.add (rs.getString("ClarificationRemarks"));
+                notice.add (rs.getString("ClientName"));
             }
            return notice;
         } catch (SQLException ex) {