[SQL-CVS] r497 - trunk/SQLObject/sqlobject

[<sub...@co...>]

Author: phd
Date: 2004-12-28 08:37:02 +0000 (Tue, 28 Dec 2004)
New Revision: 497

Modified:
   trunk/SQLObject/sqlobject/dbconnection.py
Log:
Fixed a bug with tables that do not have columns (only MultipleJoins, e.g.)

Modified: trunk/SQLObject/sqlobject/dbconnection.py
===================================================================
--- trunk/SQLObject/sqlobject/dbconnection.py	2004-12-28 08:25:11 UTC (rev 496)
+++ trunk/SQLObject/sqlobject/dbconnection.py	2004-12-28 08:37:02 UTC (rev 497)
@@ -268,11 +268,16 @@
                  (cls._table, cls._idName,
                   ", ".join(select.tables))
         else:
-            q += "%s.%s, %s FROM %s WHERE " % \
-                 (cls._table, cls._idName,
-                  ", ".join(["%s.%s" % (cls._table, col.dbName)
-                             for col in cls._SO_columns]),
-                  ", ".join(select.tables))
+            columns = ", ".join(["%s.%s" % (cls._table, col.dbName)
+                                 for col in cls._SO_columns])
+            if columns:
+                q += "%s.%s, %s FROM %s WHERE " % \
+                     (cls._table, cls._idName, columns,
+                      ", ".join(select.tables))
+            else:
+                q += "%s.%s FROM %s WHERE " % \
+                     (cls._table, cls._idName,
+                      ", ".join(select.tables))
 
         return self._addWhereClause(select, q)