That's cheap. It's under sorting. I wasn't sorting. I was filtering. Nobody is going to look there if they are filtering. Sorting is sorting, filtering is filtering.
auurrrgh! On Mon, 2003-01-27 at 17:27, Henner Kollmann wrote: > Sorry, the second point is in the documentation: > > DbForms_UserGuide_v1_1_3pr1_pdf.pdf, chapter 7.2, page 65: > > Basically, this is all you need to write! This functionality even works > within nested forms. But there is one important configuration issue you > should be aware of: all non-key-fields you want to be sortable should be > declared sortable in the XML-config file: > > > Regards, > Henner > > > -----Urspr�ngliche Nachricht----- > > Von: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED]] Im > > Auftrag von shawn > > Gesendet: Montag, 27. Januar 2003 02:10 > > An: [EMAIL PROTECTED] > > Betreff: [dbforms] imporatant navigation tips > > > > > > Dear Everyone. > > > > The following two details are not in dbforms documentation to > > the best of my knowledge and could very well effect the > > navigation on your pages. > > > > #1] whereClause --- using this function renders navigation > > impossible! > > For instance, if you specify "where n>3" and your user views the page > > and then clicks the navNext button, the next page may show > > values where n is not greater than 3. > > > > Also, the whereClause can not be used with orderBy or filter > > attributes. They will be ignored. Order by should be used > > within the whereClause > > instead: > > > > whereClause="WHERE > > (FIELD1 >'25' AND FIELD1 <'50' ) OR FIELD2 NOT NULL ORDERBY FIELD7" > > > > ...So if you want to use navNext/navPrev buttons, you should > > use orderBy and filter attributes instead of a whereClause > > > > #2] orderBy -- if you use a non-primary key, you MUST > > specify sortable="true" within your dbforms-config.xml file. > > If you use orderBy with a non primary key and you don't > > specify that in the config file, then navNext/navPrev buttons > > will function like navLast/navFirst buttons and you will skip > > over results. > > > > If you are following these two rules and still have > > navigation problems, please let us know so that we can > > eliminate any bugs in dbforms navigation. > > > > Considerately, > > > > -- > > shawn <[EMAIL PROTECTED]> > > > > > > > > ------------------------------------------------------- > > This SF.NET email is sponsored by: > > SourceForge Enterprise Edition + IBM + LinuxWorld = Something > > 2 See! http://www.vasoftware.com > > _______________________________________________ > > DbForms Mailing List > > > http://www.wap-force.net/dbforms > > > > ------------------------------------------------------- > This SF.NET email is sponsored by: > SourceForge Enterprise Edition + IBM + LinuxWorld http://www.vasoftware.com > _______________________________________________ > DbForms Mailing List > > http://www.wap-force.net/dbforms -- shawn <[EMAIL PROTECTED]> ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
