[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    koffice/kexi/kexidb
From:       Jaroslaw Staniek <js () iidea ! pl>
Date:       2008-11-05 21:01:43
Message-ID: 1225918903.098271.12319.nullmailer () svn ! kde ! org
[Download RAW message or body]

SVN commit 880560 by staniek:

explicitly convert QString() to QVariant() for sqlWhere()


 M  +4 -2      connection.cpp  


--- trunk/koffice/kexi/kexidb/connection.cpp #880559:880560
@@ -2972,7 +2972,8 @@
         return false;
     return querySingleString(
                QString("SELECT o_data FROM kexi__objectdata WHERE o_id=") + QString::number(objectID)
-               + " AND " + KexiDB::sqlWhere(m_driver, KexiDB::Field::Text, "o_sub_id", dataID),
+               + " AND " + KexiDB::sqlWhere(m_driver, KexiDB::Field::Text, "o_sub_id", 
+                                            dataID.isEmpty() ? QVariant() : QVariant(dataID)),
                dataString);
 }
 
@@ -2982,7 +2983,8 @@
         return false;
     QString sql(QString::fromLatin1(
                     "SELECT kexi__objectdata.o_id FROM kexi__objectdata WHERE o_id=%1").arg(objectID));
-    QString sql_sub(KexiDB::sqlWhere(m_driver, KexiDB::Field::Text, "o_sub_id", dataID));
+    QString sql_sub(KexiDB::sqlWhere(m_driver, KexiDB::Field::Text, "o_sub_id", 
+                                     dataID.isEmpty() ? QVariant() : QVariant(dataID)));
 
     bool ok, exists;
     exists = resultExists(sql + " and " + sql_sub, ok);
[prev in list] [next in list] [prev in thread] [next in thread]