[Erp5-report] r19699 - /erp5/trunk/products/ERP5/Tool/DomainTool.py

[nobody at svn.erp5.org]

Author: seb
Date: Wed Mar  5 13:20:09 2008
New Revision: 19699

URL: http://svn.erp5.org?rev=19699&view=rev
Log:
use 0 for None values instead of NULL in order to make it compatible with primary keys

Modified:
    erp5/trunk/products/ERP5/Tool/DomainTool.py

Modified: erp5/trunk/products/ERP5/Tool/DomainTool.py
URL: http://svn.erp5.org/erp5/trunk/products/ERP5/Tool/DomainTool.py?rev=19699&r1=19698&r2=19699&view=diff
==============================================================================
--- erp5/trunk/products/ERP5/Tool/DomainTool.py (original)
+++ erp5/trunk/products/ERP5/Tool/DomainTool.py Wed Mar  5 13:20:09 2008
@@ -149,12 +149,13 @@
 
       if tested_base_category_list != []:
         # Add predicate_category.uid for automatic join
-        sql_kw['predicate_category.uid'] = '!=0'
+        sql_kw['predicate_category.uid'] = '!=NULL'
         if len(category_list)==0:
           category_list = ['NULL']
         category_expression = portal_categories.buildSQLSelector(
                                            category_list,
-                                           query_table='predicate_category')
+                                           query_table='predicate_category',
+                                           none_sql_value=0)
         if len(where_expression) > 0:
           where_expression = '(%s) AND \n(%s)' % \
                                           (where_expression,category_expression)