# HG changeset patch
# User catherine@dellzilla
# Date 1225224778 14400
# Node ID 87eb1c6ed59b559f07d8ed0104a384fe777b1b57
# Parent  210d01022343738244534d15f75d14a25a874204
fixed comments bug

diff -r 210d01022343 -r 87eb1c6ed59b sqlpython/sqlpyPlus.py
--- a/sqlpython/sqlpyPlus.py	Tue Oct 28 16:06:45 2008 -0400
+++ b/sqlpython/sqlpyPlus.py	Tue Oct 28 16:12:58 2008 -0400
@@ -660,8 +660,10 @@
         if object_type:
             self.curs.execute(queries['tabComments'],{'table_name':object_name, 'owner':owner})
             self.stdout.write("%s %s.%s: %s\n" % (object_type, owner, object_name, self.curs.fetchone()[0]))
-            query = 'oneColComments' if colName else 'colComments'
-            self.do_select(queries[query],bindVarsIn={'owner':owner, 'object_name': object_name, 'column_name': colName})
+            if colName:
+                self.do_select(queries['oneColComments'],bindVarsIn={'owner':owner, 'object_name': object_name, 'column_name': colName})
+            else:
+                self.do_select(queries['colComments'],bindVarsIn={'owner':owner, 'object_name': object_name})
 
     def resolve(self, identifier):
         """Checks (my objects).name, (my synonyms).name, (public synonyms).name