[Erp5-report] r14936 - in /erp5/trunk/products/ZSQLCatalog: SQLCatalog.py __init__.py

[nobody at svn.erp5.org]

Author: romain
Date: Fri Jun 22 18:15:58 2007
New Revision: 14936

URL: http://svn.erp5.org?rev=14936&view=rev
Log:
Add 'nlt' (Not Less Than) keyword in asSQLExpression.

Modified:
    erp5/trunk/products/ZSQLCatalog/SQLCatalog.py
    erp5/trunk/products/ZSQLCatalog/__init__.py

Modified: erp5/trunk/products/ZSQLCatalog/SQLCatalog.py
URL: http://svn.erp5.org/erp5/trunk/products/ZSQLCatalog/SQLCatalog.py?rev=14936&r1=14935&r2=14936&view=diff
==============================================================================
--- erp5/trunk/products/ZSQLCatalog/SQLCatalog.py (original)
+++ erp5/trunk/products/ZSQLCatalog/SQLCatalog.py Fri Jun 22 18:15:58 2007
@@ -333,6 +333,8 @@
         where_expression.append("%s >= %s and %s <= %s" % (key, query_min, key, query_max))
       elif range_value == 'ngt' :
         where_expression.append("%s <= %s" % (key, query_max))
+      elif range_value == 'nlt' :
+        where_expression.append("%s > %s" % (key, query_max))
     elif isSimpleType(value) or isinstance(value, DateTime) \
         or isinstance(value, (list, tuple)):
       # Convert into lists any value which contain a ;

Modified: erp5/trunk/products/ZSQLCatalog/__init__.py
URL: http://svn.erp5.org/erp5/trunk/products/ZSQLCatalog/__init__.py?rev=14936&r1=14935&r2=14936&view=diff
==============================================================================
--- erp5/trunk/products/ZSQLCatalog/__init__.py (original)
+++ erp5/trunk/products/ZSQLCatalog/__init__.py Fri Jun 22 18:15:58 2007
@@ -42,4 +42,4 @@
     context.registerHelpTitle('Zope Help')
 
 from AccessControl import ModuleSecurityInfo, ClassSecurityInfo
-ModuleSecurityInfo('Products.ZSQLCatalog.SQLCatalog').declarePublic('ComplexQuery', 'Query')
+ModuleSecurityInfo('Products.ZSQLCatalog.SQLCatalog').declarePublic('ComplexQuery', 'Query')