From 8473e67f10f614ee932051b416881b2fa46ab195 Mon Sep 17 00:00:00 2001
From: Mathew McBride <matt@Mcbridematt.dhs.org>
Date: Fri, 24 Jul 2009 19:13:50 +1000
Subject: [PATCH] Fix name-match SQL select

---
 .../java/net/bionicmessage/objects/MultipleSourceObjectTracking.java  | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/main/java/net/bionicmessage/objects/MultipleSourceObjectTracking.java b/src/main/java/net/bionicmessage/objects/MultipleSourceObjectTracking.java
index 9d91812..5ae93d4 100644
--- a/src/main/java/net/bionicmessage/objects/MultipleSourceObjectTracking.java
+++ b/src/main/java/net/bionicmessage/objects/MultipleSourceObjectTracking.java
@@ -232,8 +232,8 @@ public class MultipleSourceObjectTracking {
     }
     public ArrayList findObjectsByName(String name) throws SQLException {
         ArrayList<String> results = new ArrayList();
-        PreparedStatement findUID = conn.prepareStatement("`select `obj_uid` from namelist where `obj_name` = ?");
-        findUID.setString(0, name);
+        PreparedStatement findUID = conn.prepareStatement("select namelist.obj_uid from namelist where namelist.obj_name = ?");
+        findUID.setString(1, name);
         ResultSet rs = findUID.executeQuery();
         while (rs.next()) {
             String id = rs.getString("OBJ_UID");
-- 
2.11.4.GIT