diff options
| author | Michael Wilson | 2014-10-30 11:31:07 +0100 |
|---|---|---|
| committer | Michael Wilson | 2014-10-30 11:31:07 +0100 |
| commit | c571582cc61c122edfcaae773a23ea4f90b68a95 (patch) | |
| tree | 0ba0c5d87190bed17fad8e3addb6c3243bf9b177 /dozentenmodulserver/src/main/java/sql | |
| parent | Fixed bug when filtering for images (diff) | |
| download | tutor-module-c571582cc61c122edfcaae773a23ea4f90b68a95.tar.gz tutor-module-c571582cc61c122edfcaae773a23ea4f90b68a95.tar.xz tutor-module-c571582cc61c122edfcaae773a23ea4f90b68a95.zip | |
Fixed bug: returned wrong content for lectures
Diffstat (limited to 'dozentenmodulserver/src/main/java/sql')
| -rw-r--r-- | dozentenmodulserver/src/main/java/sql/SQL.java | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/dozentenmodulserver/src/main/java/sql/SQL.java b/dozentenmodulserver/src/main/java/sql/SQL.java index 2effe4c7..4f6321eb 100644 --- a/dozentenmodulserver/src/main/java/sql/SQL.java +++ b/dozentenmodulserver/src/main/java/sql/SQL.java @@ -508,7 +508,7 @@ public class SQL { ResultSet res = stm
.executeQuery("SELECT DISTINCT l.lectureID, l.name, l.isActive, l.startTime, l.endTime, l.lastUsed, l.description, i.image_name, concat(u.Nachname,' ',u.Vorname) as user "
+ "FROM bwLehrpool.m_VLData_lecture l, bwLehrpool.m_VLData_imageInfo i, bwLehrpool.pm_VLData_lecture pml, bwLehrpool.m_user u "
- + "WHERE i.GUID_imageID=l.imageID AND pml.rec_read=true AND u.userID=pml.userID AND u.userID='"
+ + "WHERE i.GUID_imageID=l.imageID AND l.lectureID=pml.lectureID AND pml.rec_read=true AND u.userID=pml.userID AND u.userID='"
+ userID + "';");
while (res.next()) {
@@ -569,7 +569,7 @@ public class SQL { ResultSet res = stm
.executeQuery("SELECT DISTINCT l.lectureID, l.name, l.isActive, l.startTime, l.endTime, l.lastUsed, l.description, i.image_name, concat(u.Nachname,' ',u.Vorname) as user "
+ "FROM bwLehrpool.m_VLData_lecture l, bwLehrpool.m_VLData_imageInfo i, bwLehrpool.pm_VLData_lecture pml, bwLehrpool.m_user u "
- + "WHERE i.GUID_imageID=l.imageID AND pml.rec_admin=true AND u.userID=pml.userID AND u.userID='"
+ + "WHERE i.GUID_imageID=l.imageID AND pml.rec_admin=true AND l.lectureID=pml.lectureID AND u.userID=pml.userID AND u.userID='"
+ userID + "';");
while (res.next()) {
|