For 1.1.4 developer releases (weekly releases of which are actually used in some production environments) you have the option of using the dataList navigation system.
Anyway, to answer your question AFAIK under the classic navigation system in 1.1.3, only a subset of results is returned in the query that gets built so I do not believe PAGED TABLES would be possible under classic navigation. For SORTING, again since a subset is being returned, I think you could only sort within the subset.
Under 1.1.4 using dataList navigation, all results are returned so it would seem possible to do PAGED TABLES (but I really don't know how and believe some tinkering might need to be done to allow it).
I am less clear about how sorting works with dataList navigation but suggest getting a weekly build and trying out the new "filter" tag (not
the filter attribute in the dbform tag which is an improved way to filter/sort. I am not sure if it is 100% finished but give it a shot because I think it will
do what you want. There is an example in the bookstore example
-- see /bookstore/tests/testAuthorBooksSubFormWithFilter.jsp
Shawn
PS Excuse my poor answer.
Hi all, I have 2 questions about using dbforms.
1. PAGED TABLES Can i produce (using jdbform) a "paged-table" of records. With "paged-table" i mean a table with n records for each page and with m pages of results to display (n*m) records?
2. SORTING
Using sortable fields I can sort the data within the current displayed resultset (so if I have 20 record in the current resultset I can sort only that records)...
Is there a way to obtain a table with 20 records but, if the user asks to sort them, the form displays the first 20 records of the database sorted by user request?
Thanx
PS Excuse my poor english.
Ivan
-- Shawn
Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
