From c3ebff840c108a6b0f8af79e776f509cec12b13a Mon Sep 17 00:00:00 2001 From: Nils Schwabe Date: Mon, 25 Aug 2014 14:09:54 +0200 Subject: Add accidentally removed apostrophes back to DbImage --- src/main/java/org/openslx/satellitedaemon/db/DbImage.java | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'src') diff --git a/src/main/java/org/openslx/satellitedaemon/db/DbImage.java b/src/main/java/org/openslx/satellitedaemon/db/DbImage.java index be968b9..db90116 100644 --- a/src/main/java/org/openslx/satellitedaemon/db/DbImage.java +++ b/src/main/java/org/openslx/satellitedaemon/db/DbImage.java @@ -45,21 +45,21 @@ public class DbImage public static List getAllMarkedForUpload() { return MySQL.findAll( DbImage.class, "SELECT image.GUID_imageID, image.image_name, image.imageVersion, image.image_path," + - " Concat(user.loginName, @, institution.name) AS userID, image.image_filesize" + + " Concat(user.loginName, '@', institution.name) AS userID, image.image_filesize" + " FROM m_VLData_imageInfo image" + " INNER JOIN m_user user ON (image.image_owner = user.userID)" + " INNER JOIN m_institution institution ON (institution.institutionID = user.institution)" + - " WHERE image_syncMode = to_be_published" ); + " WHERE image_syncMode = 'to_be_published'" ); } public static List getAllMarkedForDownload() { return MySQL.findAll( DbImage.class, "SELECT image.GUID_imageID, image.image_name, image.imageVersion, image.image_path," + - " Concat(user.loginName, @, institution.name) AS userID, image.image_filesize" + + " Concat(user.loginName, '@', institution.name) AS userID, image.image_filesize" + " FROM m_VLData_imageInfo image" + " INNER JOIN m_user user ON (image.image_owner = user.userID)" + " INNER JOIN m_institution institution ON (institution.institutionID = user.institution)" + - " WHERE image_syncMode = to_be_decentralized" ); + " WHERE image_syncMode = 'to_be_decentralized'" ); } public static void updateStatus( String uuid, Status status ) -- cgit v1.2.3-55-g7522