Re: [SQL-Ledger-users] LARGE INVENTORY

[Thomas S. <ps...@on...>]

Well for starters we simply need to create a start record count variable
and an end record count variable: $form->{startcnt} and $form->{endcnt}.
For now fix them to 0 and 1000, respectivly.

Then in the search_for_item function in the ic.cgi script replace:

$query = qq|SELECT id, number, description, onhand, unit, sellprice
                   FROM parts WHERE $where
                   ORDER BY $from->{sort}
           |;

with:

$query = qq|SELECT id, number, description, onhand, unit, sellprice
                   FROM parts WHERE $where
                   ORDER BY $from->{sort}
                   LIMIT $form->{endcnt}, $form-{startcnt}
           |;

This should work fine and open it up for adding pages down the line.

-- 
Thomas Sawyer
ps...@on... - email
(303) 285-3487 x1594 - voicemail/fax



---- Matt Benjamin <ma...@li...> wrote:
> 
> The feature is easy enough to code, and I'd be willing to, but it sounds
> like Dieter needs a little more convincing of its utility :)
> 
> 
> Matt
> 
> 
> >
> > So who wants to do it?
> >
> 
> 
> 

__________________________________________________
FREE voicemail, email, and fax...all in one place.
Sign Up Now! http://www.onebox.com