summaryrefslogtreecommitdiff
Unidiff
Diffstat (more/less context) (ignore whitespace changes)
-rw-r--r--libopie2/opiepim/backend/ocontactaccessbackend_sql.cpp8
1 files changed, 7 insertions, 1 deletions
diff --git a/libopie2/opiepim/backend/ocontactaccessbackend_sql.cpp b/libopie2/opiepim/backend/ocontactaccessbackend_sql.cpp
index 6aaa14c..f684f8c 100644
--- a/libopie2/opiepim/backend/ocontactaccessbackend_sql.cpp
+++ b/libopie2/opiepim/backend/ocontactaccessbackend_sql.cpp
@@ -648,7 +648,7 @@ UIDArray OPimContactAccessBackend_SQL::queryByExample ( const UIDArray& uidlist,
648 648
649 // The following if line is a replacement for 649 // The following if line is a replacement for
650 // if ( searchQuery.endsWith( "AND" ) ) 650 // if ( searchQuery.endsWith( "AND" ) )
651 if ( searchQuery.findRev( "AND" ) == ( searchQuery.length() - 3 ) ){ 651 if ( searchQuery.findRev( "AND" ) == static_cast<int>( searchQuery.length() - 3 ) ){
652 odebug << "remove AND" << oendl; 652 odebug << "remove AND" << oendl;
653 searchQuery.remove( searchQuery.length()-3, 3 ); // Hmmmm.. 653 searchQuery.remove( searchQuery.length()-3, 3 ); // Hmmmm..
654 } 654 }
@@ -873,6 +873,12 @@ UIDArray OPimContactAccessBackend_SQL::sorted( const UIDArray& ar, bool asc, int
873 case OPimContactAccess::SortGender: 873 case OPimContactAccess::SortGender:
874 query += " \"Gender\""; 874 query += " \"Gender\"";
875 break; 875 break;
876 case OPimContactAccess::SortBirthdayWithoutYear:
877 query += " substr(\"Birthday\", 6, 10)";
878 break;
879 case OPimContactAccess::SortAnniversaryWithoutYear:
880 query += " substr(\"Anniversary\", 6, 10)";
881 break;
876 default: 882 default:
877 query += " \"Last Name\""; 883 query += " \"Last Name\"";
878 } 884 }