From e271ae697e477a9e9e4ca21db0b90fc21787e0aa Mon Sep 17 00:00:00 2001 From: Dirk H Bartley Date: Mon, 4 Jun 2007 16:07:16 +0000 Subject: [PATCH] Fix for mysql capital sensitive from select statement. git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@4979 91ce42f0-d328-0410-95d8-f526ca767f89 --- bacula/src/qt-console/restore/restoretree.cpp | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) diff --git a/bacula/src/qt-console/restore/restoretree.cpp b/bacula/src/qt-console/restore/restoretree.cpp index 0c125cc716..5adf3f94a0 100644 --- a/bacula/src/qt-console/restore/restoretree.cpp +++ b/bacula/src/qt-console/restore/restoretree.cpp @@ -307,13 +307,13 @@ void restoreTree::directoryItemChanged(QTreeWidgetItem *item, QTreeWidgetItem *) QString directory = item->data(0,Qt::UserRole).toString(); directoryLabel->setText("Present Working Directory : " + directory); QString cmd = - "SELECT DISTINCT FileName.Name" - " FROM File LEFT OUTER JOIN Filename on (FileName.FileNameId=File.FileNameId)" + "SELECT DISTINCT Filename.Name" + " FROM File LEFT OUTER JOIN Filename on (Filename.FilenameId=File.FilenameId)" " LEFT OUTER JOIN Path ON (Path.PathId=File.PathId)" " LEFT OUTER JOIN Job ON (File.JobId=Job.JobId)" " LEFT OUTER JOIN Client ON (Job.ClientId=Client.ClientId)" " LEFT OUTER JOIN FileSet ON (Job.FileSetId=FileSet.FileSetId)"; - cmd += " WHERE Path.Path='" + directory + "' AND FileName.Name!='' AND " + m_condition; + cmd += " WHERE Path.Path='" + directory + "' AND Filename.Name!='' AND " + m_condition; QStringList headerlist = (QStringList() << "File Name"); fileTable->clear(); @@ -374,12 +374,12 @@ void restoreTree::fileItemChanged(QTableWidgetItem *fileTableItem, QTableWidgetI QString cmd = "SELECT File.FileId, Job.JobId, Job.EndTime, File.Md5 " " FROM File" - " LEFT OUTER JOIN Filename on (FileName.FileNameId=File.FileNameId)" + " LEFT OUTER JOIN Filename on (Filename.FilenameId=File.FilenameId)" " LEFT OUTER JOIN Path ON (Path.PathId=File.PathId)" " LEFT OUTER JOIN Job ON (File.JobId=Job.JobId)" " LEFT OUTER JOIN Client ON (Job.ClientId=Client.ClientId)" " LEFT OUTER JOIN FileSet ON (Job.FileSetId=FileSet.FileSetId)"; - cmd += " WHERE FileName.Name='" + file + "' AND Path.Path='" + directory + "' AND " + m_condition; + cmd += " WHERE Filename.Name='" + file + "' AND Path.Path='" + directory + "' AND " + m_condition; QStringList headerlist = (QStringList() << "File Id" << "Job Id" << "End Time" << "Md5"); versionTable->clear(); -- 2.39.5