diff roundup/backends/rdbms_common.py @ 1295:9c3459cb8ab6

work-around for sqlite bug
author Richard Jones <richard@users.sourceforge.net>
date Thu, 31 Oct 2002 04:02:23 +0000
parents 209a47ede743
children 61ad556cfc8d
line wrap: on
line diff
--- a/roundup/backends/rdbms_common.py	Mon Oct 21 22:03:09 2002 +0000
+++ b/roundup/backends/rdbms_common.py	Thu Oct 31 04:02:23 2002 +0000
@@ -1,4 +1,4 @@
-# $Id: rdbms_common.py,v 1.22 2002-10-08 04:11:16 richard Exp $
+# $Id: rdbms_common.py,v 1.23 2002-10-31 04:02:23 richard Exp $
 ''' Relational database (SQL) backend common code.
 
 Basics:
@@ -1767,9 +1767,12 @@
                         xtra = ' or _%s is NULL'%k
                     else:
                         xtra = ''
-                    s = ','.join([a for x in v])
-                    where.append('(_%s in (%s)%s)'%(k, s, xtra))
-                    args = args + v
+                    if v:
+                        s = ','.join([a for x in v])
+                        where.append('(_%s in (%s)%s)'%(k, s, xtra))
+                        args = args + v
+                    else:
+                        where.append('_%s is NULL'%k)
                 else:
                     if v == '-1':
                         v = None

Roundup Issue Tracker: http://roundup-tracker.org/