[gnue] r7348 - trunk/gnue-common/src/datasources/drivers/DBSIG2

[johannes]

Author: johannes
Date: 2005-04-12 04:22:53 -0500 (Tue, 12 Apr 2005)
New Revision: 7348

Modified:
   trunk/gnue-common/src/datasources/drivers/DBSIG2/ResultSet.py
Log:
Use UPPER for case-insensitive sorting instead of LOWER, since it is supported 
by Firebird/Interbase without using an UDF


Modified: trunk/gnue-common/src/datasources/drivers/DBSIG2/ResultSet.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/DBSIG2/ResultSet.py       
2005-04-12 09:18:09 UTC (rev 7347)
+++ trunk/gnue-common/src/datasources/drivers/DBSIG2/ResultSet.py       
2005-04-12 09:22:53 UTC (rev 7348)
@@ -56,7 +56,7 @@
         descending = item.get ('descending') or False
         ignorecase = item.get ('ignorecase') or False
 
-        fmt = ignorecase and "LOWER (%s)%s" or "%s%s"
+        fmt = ignorecase and "UPPER (%s)%s" or "%s%s"
         order.append (fmt % (field, descending and ' DESC' or ''))
 
       query += ' ORDER BY ' + string.join (order, ', ')