gnue/common/src/dbdrivers/_dbsig DBdriver.py

[James Thompson]

CVSROOT:        /cvsroot/gnue
Module name:    gnue
Changes by:     James Thompson <address@hidden> 02/11/11 15:51:16

Modified files:
        common/src/dbdrivers/_dbsig: DBdriver.py 

Log message:
        distinct support fix

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue/common/src/dbdrivers/_dbsig/DBdriver.py.diff?tr1=1.61&tr2=1.62&r1=text&r2=text

Patches:
Index: gnue/common/src/dbdrivers/_dbsig/DBdriver.py
diff -c gnue/common/src/dbdrivers/_dbsig/DBdriver.py:1.61 
gnue/common/src/dbdrivers/_dbsig/DBdriver.py:1.62
*** gnue/common/src/dbdrivers/_dbsig/DBdriver.py:1.61   Thu Nov  7 22:21:01 2002
--- gnue/common/src/dbdrivers/_dbsig/DBdriver.py        Mon Nov 11 15:51:16 2002
***************
*** 544,550 ****
              whereClause)
      else:
        self._primaryIdSelect = None
!       q = "SELECT %s* FROM %s%s" % (self.distinct, self.table,
                          whereClause)
  
      if hasattr(self,'order_by') and not forDetail:
--- 544,550 ----
              whereClause)
      else:
        self._primaryIdSelect = None
!       q = "SELECT %s* FROM %s%s" % (distinct, self.table,
                          whereClause)
  
      if hasattr(self,'order_by') and not forDetail:
***************
*** 568,574 ****
          whereClause = ' WHERE %s' % (additionalSQL)
  
  
!     q = "SELECT count(*) FROM %s%s" % (self.table, whereClause)
  
      GDebug.printMesg(5,q)
  
--- 568,574 ----
          whereClause = ' WHERE %s' % (additionalSQL)
  
  
!     q = "SELECT count(%s*) FROM %s%s" % (distinct, self.table, whereClause)
  
      GDebug.printMesg(5,q)