[Erp5-report] r15450 - /erp5/trunk/products/ZSQLCatalog/SQLCatalog.py

[nobody at svn.erp5.org]

Author: vincent
Date: Fri Aug  3 14:05:01 2007
New Revision: 15450

URL: http://svn.erp5.org?rev=15450&view=rev
Log:
Oops, if value is a list-like type has just one item, use the item, not the value.

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=15450&r1=15449&r2=15450&view=diff
==============================================================================
--- erp5/trunk/products/ZSQLCatalog/SQLCatalog.py (original)
+++ erp5/trunk/products/ZSQLCatalog/SQLCatalog.py Fri Aug  3 14:05:01 2007
@@ -404,7 +404,7 @@
         escaped_value_string = ', '.join(escaped_value_list)
         where_expression.append("%s IN (%s)" % (key, escaped_value_string))
       elif len(value) == 1:
-        where_expression.append("%s == %s" % (key, self._quoteSQLString(value)))
+        where_expression.append("%s == %s" % (key, self._quoteSQLString(value[0])))
       else:
         where_expression.append('0') # "foo IN ()" is invalid SQL syntax, so use a "false" value.
     else: