diff options
| author | Michael Wilson | 2014-11-17 14:57:28 +0100 |
|---|---|---|
| committer | Michael Wilson | 2014-11-17 14:57:28 +0100 |
| commit | 0fdf139a73909330f56837cbf17a5a53e223d456 (patch) | |
| tree | b8637eb48552c11f65717986d4880ace4e412873 /dozentenmodulserver/src/main/java/sql/SQL.java | |
| parent | Navigation korrigiert (diff) | |
| download | tutor-module-0fdf139a73909330f56837cbf17a5a53e223d456.tar.gz tutor-module-0fdf139a73909330f56837cbf17a5a53e223d456.tar.xz tutor-module-0fdf139a73909330f56837cbf17a5a53e223d456.zip | |
-
Diffstat (limited to 'dozentenmodulserver/src/main/java/sql/SQL.java')
| -rw-r--r-- | dozentenmodulserver/src/main/java/sql/SQL.java | 5 |
1 files changed, 3 insertions, 2 deletions
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"));
|