From: Philipp Spitzer <philipp@spitzer.priv.at>
Date: Sun, 26 Jun 2011 18:26:09 +0000 (+0000)
Subject: The '%' character doesn't have to be escaped anymore.
X-Git-Tag: 0.5.0~7
X-Git-Url: https://git.toastfreeware.priv.at/toast/confclerk.git/commitdiff_plain/f48bf9f14f9c84725cfeb81ee89805981efbc3f7

The '%' character doesn't have to be escaped anymore.
---

diff --git a/src/gui/searchtabcontainer.cpp b/src/gui/searchtabcontainer.cpp
index d9b050c..246b4ea 100644
--- a/src/gui/searchtabcontainer.cpp
+++ b/src/gui/searchtabcontainer.cpp
@@ -83,8 +83,7 @@ void SearchTabContainer::searchButtonClicked()
     if( searchHeader->searchRoom->isChecked() )
         columns["ROOM"] = "name";
 
-    QString keyword = searchHeader->searchEdit->text().replace( QString("%"), QString("\\%") );
-    //qDebug() << "\nKeyword to search: " << keyword;
+    QString keyword = searchHeader->searchEdit->text();
 
     int confId = Conference::activeConference();
     SqlEngine::searchEvent( confId, columns, keyword );
diff --git a/src/sql/sqlengine.cpp b/src/sql/sqlengine.cpp
index 9f0f1e2..810f716 100644
--- a/src/sql/sqlengine.cpp
+++ b/src/sql/sqlengine.cpp
@@ -309,7 +309,7 @@ int SqlEngine::searchEvent(int aConferenceId, const QHash<QString,QString> &aCol
     // DROP
     execQuery( db, "DROP TABLE IF EXISTS SEARCH_EVENT");
     // CREATE
-    execQuery( db, "CREATE TEMP TABLE SEARCH_EVENT ( xid_conference INTEGER  NOT NULL, id INTEGER NOT NULL )");
+    execQuery( db, "CREATE TABLE SEARCH_EVENT ( xid_conference INTEGER  NOT NULL, id INTEGER NOT NULL )");
     // INSERT
     QString sql = QString("INSERT INTO SEARCH_EVENT ( xid_conference, id ) "
                 "SELECT EVENT.xid_conference, EVENT.id FROM EVENT ");