From 8f31f5336ecd0f42397e7bdd930e654ad420795c Mon Sep 17 00:00:00 2001 From: Kern Sibbald Date: Fri, 6 Mar 2009 12:54:02 +0000 Subject: [PATCH] Fix Upper/Lower case in SQL git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@8501 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/src/qt-console/relabel/relabel.cpp | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/bacula/src/qt-console/relabel/relabel.cpp b/bacula/src/qt-console/relabel/relabel.cpp index 1aadbd7d81..8afc3a8f83 100644 --- a/bacula/src/qt-console/relabel/relabel.cpp +++ b/bacula/src/qt-console/relabel/relabel.cpp @@ -68,10 +68,10 @@ int relabelDialog::getDefs(QStringList &fieldlist) { QString job, client, fileset; QString query(""); - query = "SELECT mediatype AS MediaType, pool.name AS PoolName" - " FROM media" - " LEFT OUTER JOIN pool ON media.poolid = pool.poolid" - " WHERE volumename = \'" + m_fromVolume + "\'"; + query = "SELECT MediaType AS MediaType, Pool.Name AS PoolName" + " FROM Media" + " LEFT OUTER JOIN Pool ON Media.PoolId = Pool.PoolId" + " WHERE VolumeName = \'" + m_fromVolume + "\'"; if (mainWin->m_sqlDebug) { Pmsg1(000, "query = %s\n", query.toUtf8().data()); } QStringList results; if (m_console->sql_cmd(query, results)) { -- 2.39.5