Author: johannes
Date: 2007-05-05 12:59:06 -0500 (Sat, 05 May 2007)
New Revision: 9550
Modified:
trunk/gnue-common/src/datasources/drivers/DBSIG2/ResultSet.py
Log:
Don't make a space between function name and argument, so it does work
on mySQL too
Modified: trunk/gnue-common/src/datasources/drivers/DBSIG2/ResultSet.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/DBSIG2/ResultSet.py 2007-05-05 12:13:54 UTC (rev 9549)
+++ trunk/gnue-common/src/datasources/drivers/DBSIG2/ResultSet.py 2007-05-05 17:59:06 UTC (rev 9550)
@@ -114,7 +114,7 @@
descending = item.get ('descending') or False
ignorecase = item.get ('ignorecase') or False
- fmt = ignorecase and "UPPER (%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 ' + ', '.join (order)
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.