[SQL-CVS] SQLObject/SQLObject DBConnection.py,1.36,1.37

[<ian...@us...>]

Update of /cvsroot/sqlobject/SQLObject/SQLObject
In directory sc8-pr-cvs1:/tmp/cvs-serv27689/SQLObject

Modified Files:
	DBConnection.py 
Log Message:
Fix a couple SQLite bugs (from Matt Goodall <ma...@po...>)


Index: DBConnection.py
===================================================================
RCS file: /cvsroot/sqlobject/SQLObject/SQLObject/DBConnection.py,v
retrieving revision 1.36
retrieving revision 1.37
diff -C2 -d -r1.36 -r1.37
*** DBConnection.py	28 Jun 2003 22:20:20 -0000	1.36
--- DBConnection.py	30 Jun 2003 22:43:06 -0000	1.37
***************
*** 149,153 ****
              (", ".join(select.tables),
               self.whereClauseForSelect(select, limit=0, order=0))
!         val = self.queryOne(q)[0]
          if self.debug:
              print "COUNT results:", val
--- 149,153 ----
              (", ".join(select.tables),
               self.whereClauseForSelect(select, limit=0, order=0))
!         val = int(self.queryOne(q)[0])
          if self.debug:
              print "COUNT results:", val
***************
*** 586,590 ****
              return "%s LIMIT %i" % (query, end)
          if not end:
!             return "%s OFFSET %i" % (query, start)
          return "%s LIMIT %i OFFSET %i" % (query, end-start, start)
  
--- 586,590 ----
              return "%s LIMIT %i" % (query, end)
          if not end:
!             return "%s LIMIT 0 OFFSET %i" % (query, start)
          return "%s LIMIT %i OFFSET %i" % (query, end-start, start)