[Digikam-devel] [Bug 134037] order of images returned is not same as that of current digikam view

[Debajyoti Bera]

------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
         
http://bugs.kde.org/show_bug.cgi?id=134037         




------- Additional Comments From dbera.web gmail com  2006-09-13 23:54 -------
A bad way of fixing the problems for date order would be to add replace 

execSql( QString("SELECT Albums.url||'/'||Images.name FROM Images, Albums "
                 "WHERE Albums.id=%1 AND Albums.id=Images.dirid;")

by

execSql( QString("SELECT Albums.url||'/'||Images.name FROM Images, Albums "
                 "WHERE Albums.id=%1 AND Albums.id=Images.dirid ORDER BY Images.datetime;")

Obviously this only works when the images should be returned according to date but not for anything else. A better and complete fix is in order.
Thanks.