From f5a18cfc3c0eeedf43e5d688df5471d7369226de Mon Sep 17 00:00:00 2001
From: unknown
Date: Fri, 25 Apr 2014 09:50:41 +0200
Subject: Delete Image funktioniert

---
 Dozentenmodulserver/src/sql/SQL.java | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'Dozentenmodulserver/src/sql')

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
-- 
cgit v1.2.3-55-g7522