[Erp5-report] r12578 - /erp5/trunk/products/ZSQLCatalog/SQLCatalog.py
nobody at svn.erp5.org
nobody at svn.erp5.org
Thu Feb 8 10:36:50 CET 2007
Author: nicolas
Date: Thu Feb 8 10:36:49 2007
New Revision: 12578
URL: http://svn.erp5.org?rev=12578&view=rev
Log:
Manage None value in Query
Modified:
erp5/trunk/products/ZSQLCatalog/SQLCatalog.py
Modified: erp5/trunk/products/ZSQLCatalog/SQLCatalog.py
URL: http://svn.erp5.org/erp5/trunk/products/ZSQLCatalog/SQLCatalog.py?rev=12578&r1=12577&r2=12578&view=diff
==============================================================================
--- erp5/trunk/products/ZSQLCatalog/SQLCatalog.py (original)
+++ erp5/trunk/products/ZSQLCatalog/SQLCatalog.py Thu Feb 8 10:36:49 2007
@@ -304,6 +304,9 @@
select_expression.append("MATCH %s AGAINST ('%s' %s) AS %s_relevance" % (key, value, mode,key.split('.')[1]))
else:
where_expression.append("%s = '%s'" % (key, value))
+
+ elif value is None:
+ where_expression.append("%s is NULL" % (key))
else:
where_expression.append("%s = %s" % (key, self._quoteSQLString(value)))
More information about the Erp5-report
mailing list