Re: [mv] Limit a list

[Mike Heins <mikeh@minivend.com>]

******    message to minivend-users from Mike Heins <mikeh@minivend.com>     ******

Quoting Kaare Rasmussen (kar@webline.dk):
> 
> How can I do this - if I have a search or a sql select that will return perhaps
> 100 rows, I don't want to display all 100 rows at one time, but maybe 10 at a
> time, with a next and previous button, and maybe even a first and last button,
> leading to the respective batch of rows.
> 
> This ought to be a FAQ, but I couldn't find this in the dox. Maybe I'm looking
> for the wrong keywords, but please don't bite at me.

I don't know how well this is documented, but the basic setup is:

    [query more=1 ml=10 list=1 sql="select * from products"]
    [list]
	    [sql-code] [sql-param field]<BR>
    [/list]<BR>
    [more-list]
    [more]
    [/more-list]
    [/query]

I guess it should be documented, for search/query paging is probably #1 on the
features people like in Interchange. 8-)

-- 
Akopia, Inc., 131 Willow Lane, Floor 2, Oxford, OH  45056
phone +1.513.523.8220 fax 7501 <heins@akopia.com>

Research is what I'm doing when I don't know what I'm doing.
-- Wernher Von Braun
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list