diff options
Diffstat (limited to 'Dozentenmodulserver/src/sql')
| -rw-r--r-- | Dozentenmodulserver/src/sql/SQL.java | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/Dozentenmodulserver/src/sql/SQL.java b/Dozentenmodulserver/src/sql/SQL.java index d85068e8..143efb78 100644 --- a/Dozentenmodulserver/src/sql/SQL.java +++ b/Dozentenmodulserver/src/sql/SQL.java @@ -544,8 +544,10 @@ public class SQL { try {
Statement stm = con.createStatement();
- return stm.executeQuery("SELECT image_path FROM bwLehrpool.m_VLData_imageInfo WHERE imageID = '" + imageid
- + "' AND imageVersion = '" + imageversion + "';").toString();
+ ResultSet rs=stm.executeQuery("SELECT image_path FROM bwLehrpool.m_VLData_imageInfo WHERE GUID_imageID = '" + imageid
+ + "' AND imageVersion = '" + imageversion + "';");
+ rs.next();
+ return rs.getString("image_path");
} catch (SQLException e) {
// TODO Auto-generated catch block
|
