I suggest using at least the weekly build of 20-Sep-2003 since the filter tag was revised on the 14th of September.

By the way, the filter tag will also work with classic navigation. It's trivial to switch between them (just comment out or add a few lines to the dbforms-config.xml and stop/start the context, so you can try it both ways. Actually, I am pretty sure that it will work with classic too at least for sorting. The developer created it with classic in mind.

(In current weekly builds, datalist is the default navigation system so nothing would need to be done to use it -- classic is better for large tables though if you are running into memory problems).

Thanx,
i'm using 1.1.4.pr1 (3th August release i think).
But my knowledge is about 1.1.3.....

I'm going to use dataList to test the new features.
Thanx
Ivan

*********** REPLY SEPARATOR ***********

On 22/09/2003 at 16.11 Shawn wrote:

Well what version (and navigation system ) are you using?

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/






-- 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

Reply via email to