[Scoop-checkins] scoop/lib/Scoop DB.pm

[scoop at sodium.sabren.com]

Update of /cvs/scoop/scoop/lib/Scoop
In directory sodium.sabren.com:/tmp/cvs-serv13441/lib/Scoop

Modified Files:
	DB.pm 
Log Message:
Small fix for db_select - the recent pgsql changes broke limit/offset 
handling, so everything that pages (search results, section index pages) 
were all broken.

As I understand it, this isn't compatible with pgsql. That'll have to be 
fixed in a different patch.

-janra



Index: DB.pm
===================================================================
RCS file: /cvs/scoop/scoop/lib/Scoop/DB.pm,v
retrieving revision 1.24
retrieving revision 1.25
diff -C2 -d -r1.24 -r1.25
*** DB.pm	30 Jul 2004 08:12:56 -0000	1.24
--- DB.pm	6 Aug 2004 18:31:00 -0000	1.25
***************
*** 53,57 ****
  	}
  	if ($args->{LIMIT}) {
! 		$query .= " LIMIT $args->{LIMIT}";
  	}
  	
--- 53,61 ----
  	}
  	if ($args->{LIMIT}) {
! 		$query .= " LIMIT";
! 		if ($args->{OFFSET}) {
! 			$query .= " $args->{OFFSET},";
! 		}
! 		$query .= " $args->{LIMIT}";
  	}