Re: [SQL-Ledger-users] LARGE INVENTORY

[Scott T. <gst...@te...>]

dr...@ss... wrote:
> 
> In message <Pin...@ti...>, "Roderick A.
>  Anderson" writes:
> > On Tue, 6 Feb 2001, Andrew Sharp wrote:
> >
> > >     if($CONFIG{sqllimit} == 1) {
> > >         # this presuposes a limit statement in postgresql, but
> > >         # I think it has them.  If it doesn't it can be coded
> > >         # around anyway.
> >
> > PostgreSQL does have the limit clause which I believe is in the SQL92 and
> > SQL99 standards.  It's easy to get into the MySQL (choose your own
> > database) has this feature or that thingy but for the most part PostgreSQL
> > follows the standands better than the other databases.
> >
> >    The problem with the limit statement is it is 'stateless'.  It picks
> > the first 'n' records that meet the rest of the selection criteria.
> > There is no easy way to remember the current 'n' items at the database
> > level so the the next SELECT statement can pick the next 'n' items.
> 
> There is a way to pick the next set.  Use the offset keyword.
> 
> select * from table where criteria offset START limit LENGTH
> 

Hi, 

phpGroupWare does this with the todo list (and other apps) using PHP and
MySQL or PostgreSQL.  Converting to CGI/Perl input shouldn't be too
difficult. 
Check it out at http://www.phpgroupware.org/  it's still very much in
the developement stage, I would suggest rel 0.9.1 or 0.9.2, the newer
ones seem to be more buggy. :o(

Regards.