Changeset 53effcb for src/sql/sqlengine.cpp

Timestamp:

07/10/11 21:37:00 (11 years ago)

Author:

Philipp Spitzer <philipp@…>

Branches:

master, qt5

Children:

c8a76f3

Parents:

e388cda

Message:

Fixed bug (related to ticket #12): Only the last search term is used.

File:

• src/sql/sqlengine.cpp (modified) (2 diffs)

src/sql/sqlengine.cpp

@@ -318 +318 @@
         foreach (QString column, aColumns.values(table)){
             for (int i=0; i < searchKeywords.count(); i++){
-                 sql += QString("%1.%2 LIKE '\%' || :%1%2 || '\%' OR ").arg( table, column );
+                 sql += QString("%1.%2 LIKE '\%' || :%1%2%3 || '\%' OR ").arg(table).arg(column).arg(i);
             }
         }
@@ -329 +329 @@
     foreach (QString table, aColumns.uniqueKeys()){
         foreach (QString column, aColumns.values(table)){
-            foreach (QString keyword, searchKeywords){
-                query.bindValue(QString(":%1%2").arg(table, column), keyword );
+            for (int i = 0; i != searchKeywords.size(); ++i) {
+                QString keyword = searchKeywords[i];
+                query.bindValue(QString(":%1%2%3").arg(table).arg(column).arg(i), keyword );
             }
         }