From 0fdf139a73909330f56837cbf17a5a53e223d456 Mon Sep 17 00:00:00 2001 From: Michael Wilson Date: Mon, 17 Nov 2014 14:57:28 +0100 Subject: - --- dozentenmodulserver/src/main/java/sql/SQL.java | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'dozentenmodulserver/src/main/java/sql/SQL.java') diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java index 83bd2ccb..6f04d156 100644 --- a/dozentenmodulserver/src/main/java/sql/SQL.java +++ b/dozentenmodulserver/src/main/java/sql/SQL.java @@ -1239,8 +1239,9 @@ public class SQL { Connection con = getConnection(); Statement stm = con.createStatement(); ResultSet data = stm - .executeQuery("select l.name, l.isActive, l.startTime, l.endTime, l.lastUsed, l.description, i.image_path, l.imageVersion, concat(u.Nachname,' ',u.Vorname) as owner from m_VLData_lecture l, m_user u, m_VLData_imageInfo i where l.admin_owner=u.userID and l.imageID=i.GUID_imageID and lectureID= '" - + id + "' ;"); + //.executeQuery("select l.name, l.isActive, l.startTime, l.endTime, l.lastUsed, l.description, i.image_path, l.imageVersion, concat(u.Nachname,' ',u.Vorname) as owner from m_VLData_lecture l, m_user u, m_VLData_imageInfo i where l.admin_owner=u.userID and l.imageID=i.GUID_imageID and lectureID= '" + .executeQuery("select l.name, l.isActive, l.startTime, l.endTime, l.lastUsed, l.description, i.image_path, i.imageVersion, concat(u.Nachname,' ',u.Vorname) as owner from m_VLData_lecture l, m_user u, m_VLData_imageInfo i where l.admin_owner=u.userID and l.imageID=i.GUID_imageID and lectureID= '" + + id + "' ;"); while (data.next()) { map.put("name", data.getString("name")); map.put("isActive", data.getString("isActive")); -- cgit v1.2.3-55-g7522