If I can calculate what it would be, then I could just save that position to use later in a goToButton. Otherwise, I can try to return to the original page and use NavNext from there. Either way, is there a way to do this without having to re-enter the chosen filter????
Note: This is with classic navigation on a large database. datalist navigation could be used for the subset, but when I initially load the original page to apply the filter, I have trouble unless using classic. I wish I could apply a db:filter by default to come up with an empty rsv and then that way could use datalist navigation as it would handle the (filtered) subset.
Any suggestions?
It looks like <db:dbform sqlFilter can help me but it would be nice if there was a sqlFilterAND attribute (default to true) which I could set to false
[dbformsTag.java line 1289]
if (!Util.isNull(getSqlFilter()) && !Util.isNull(requestSqlFilterString)) { sqlFilterString = " ( " + requestSqlFilterString + " ) "+ getSqlFilterJoinType() + " ( " + getSqlFilter() + " ) "; }
private string getSqlFilterJoinType(){
String jt ="AND"
if (sqlFilterAND!=true){
jt="OR";
}
return jt;
}Then I could set my <db:dbform sqlFilter to return an empty set so the user wouldn't have to wait for the full table to load (and datalist wouldn't bog things down), but when the user entered a filter value, then results would appear.
Would other changes need to be made in other places to make sure this happens consistently????
--
Shawn
Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
------------------------------------------------------- This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND _______________________________________________ DbForms Mailing List
http://www.wap-force.net/dbforms
