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

List:       kde-commits
Subject:    playground/office/pekunia/pekunia/model
From:       Ruurd Pels <ruurd () tiscali ! nl>
Date:       2005-09-06 13:08:14
Message-ID: 1126012094.300584.10834.nullmailer () svn ! kde ! org
[Download RAW message or body]

SVN commit 457737 by ruurd:

Fix byYear query.

 M  +5 -4      bookingdbhelper.cpp  


--- trunk/playground/office/pekunia/pekunia/model/bookingdbhelper.cpp #457736:457737
@@ -135,10 +135,11 @@
     QSqlQuery dq = Database::getInstance().prepare
         (
         "SELECT b.ident, b.piece, b.bookdate, b.period_ident, b.description, p.bookyear \
-        FROM booking b, period p \
-        WHERE b.admin_ident = :admin_ident \
-        AND b.journal_ident = :journal_ident \
-        AND p.bookyear = :bookyear"
+        FROM period p, booking b  \
+        WHERE p.bookyear = :bookyear \
+        AND b.period_ident = p.ident \
+        AND b.admin_ident = :admin_ident \
+        AND b.journal_ident = :journal_ident"
         );
     dq.bindValue(":admin_ident", theJournal->getAdmin()->getIdent());
     dq.bindValue(":journal_ident", theJournal->getIdent());
[prev in list] [next in list] [prev in thread] [next in thread]