Author: jflesch
Date: 2007-01-27 20:29:25 +0000 (Sat, 27 Jan 2007)
New Revision: 11632
Modified:
trunk/apps/Thaw/src/thaw/plugins/index/IndexFolder.java
Log:
Disable case sensitivity when reordering an folder
Modified: trunk/apps/Thaw/src/thaw/plugins/index/IndexFolder.java
===================================================================
--- trunk/apps/Thaw/src/thaw/plugins/index/IndexFolder.java 2007-01-27
20:24:50 UTC (rev 11631)
+++ trunk/apps/Thaw/src/thaw/plugins/index/IndexFolder.java 2007-01-27
20:29:25 UTC (rev 11632)
@@ -920,10 +920,10 @@
if (id >= 0) {
selectSt =
-
db.getConnection().prepareStatement("SELECT id FROM indexFolders WHERE parent =
? ORDER BY name");
+
db.getConnection().prepareStatement("SELECT id FROM indexFolders WHERE parent =
? ORDER BY LOWER(name)");
} else {
selectSt =
-
db.getConnection().prepareStatement("SELECT id FROM indexFolders WHERE parent
IS NULL ORDER BY name");
+
db.getConnection().prepareStatement("SELECT id FROM indexFolders WHERE parent
IS NULL ORDER BY LOWER(name)");
}
updateSt =
@@ -952,10 +952,10 @@
if (id >= 0) {
selectSt =
-
db.getConnection().prepareStatement("SELECT id FROM indexes WHERE parent = ?
ORDER BY displayName");
+
db.getConnection().prepareStatement("SELECT id FROM indexes WHERE parent = ?
ORDER BY LOWER(displayName)");
} else {
selectSt =
-
db.getConnection().prepareStatement("SELECT id FROM indexes WHERE parent IS
NULL ORDER BY displayName");
+
db.getConnection().prepareStatement("SELECT id FROM indexes WHERE parent IS
NULL ORDER BY LOWER(displayName)");
}
updateSt =
