gnue-common/src/datasources/drivers/DBSIG2 Driv...

[James Thompson]

CVSROOT:        /cvsroot/gnue
Module name:    gnue-common
Branch:         
Changes by:     James Thompson <address@hidden> 03/08/01 17:33:09

Modified files:
        src/datasources/drivers/DBSIG2: Driver.py 

Log message:
        possible fix for the
        select count(distinct *) from
        bug

CVSWeb URLs:
http://savannah.gnu.org/cgi-bin/viewcvs/gnue/gnue-common/src/datasources/drivers/DBSIG2/Driver.py.diff?tr1=1.68&tr2=1.69&r1=text&r2=text

Patches:
Index: gnue-common/src/datasources/drivers/DBSIG2/Driver.py
diff -c gnue-common/src/datasources/drivers/DBSIG2/Driver.py:1.68 
gnue-common/src/datasources/drivers/DBSIG2/Driver.py:1.69
*** gnue-common/src/datasources/drivers/DBSIG2/Driver.py:1.68   Tue Apr 29 
15:25:17 2003
--- gnue-common/src/datasources/drivers/DBSIG2/Driver.py        Fri Aug  1 
17:33:09 2003
***************
*** 581,587 ****
          whereClause = ' WHERE %s' % (additionalSQL)
  
  
!     q = "SELECT count(%s*) FROM %s%s" % (distinct, self.table, whereClause)
  
      GDebug.printMesg(5,q)
  
--- 581,590 ----
          whereClause = ' WHERE %s' % (additionalSQL)
  
  
!     if len(self._fieldReferences):
!       q = "SELECT count(%s%s) FROM %s%s" % (distinct, 
self._fieldReferences.keys()[0],self.table, whereClause)      
!     else:
!       q = "SELECT count(%s *) FROM %s%s" % (distinct, self.table, whereClause)
  
      GDebug.printMesg(5,q)