plugins/tasklist
Thomas Brüderli
bruederli at kolabsys.com
Wed Sep 19 19:05:35 CEST 2012
plugins/tasklist/drivers/database/tasklist_database_driver.php | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 51510f1665087a9017c740643f468c4cc449b9f1
Author: Thomas Bruederli <thomas at roundcube.net>
Date: Wed Sep 19 19:05:55 2012 +0200
Use CASE instead of IF statement to be compatible with postgres
diff --git a/plugins/tasklist/drivers/database/tasklist_database_driver.php b/plugins/tasklist/drivers/database/tasklist_database_driver.php
index 51d6ec1..bcc994c 100644
--- a/plugins/tasklist/drivers/database/tasklist_database_driver.php
+++ b/plugins/tasklist/drivers/database/tasklist_database_driver.php
@@ -69,7 +69,7 @@ class tasklist_database_driver extends tasklist_driver
$result = $this->rc->db->query(
"SELECT *, tasklist_id AS id FROM " . $this->db_lists . "
WHERE user_id=?
- ORDER BY IF(name='INBOX', 0, 1), name",
+ ORDER BY CASE WHEN name='INBOX' THEN 0 ELSE 1 END, name",
$this->rc->user->ID
);
More information about the commits
mailing list