So you must set it to an empty string after the first call of your form..
I see. Thanks for the tips.
Or you have an better idea?
Well, it would be nice if a sqlFilter survived navigation. In other words, from a list page that you have applied a filter on, if you navigated to a single (through urlLink), it would be great if that single page could recognize that filter so that a navNext would produce the same record as if you clicked the next link on the list page. Similarly, if a user returns to the list, it would be nice to have them be able through a goTo button to have the same filter applied.
I.e. List page --> apply filter ---> linkUrl to single page---> single page can recognize filter--->Nav Next can navigated to the next record applying the filter --> ability to return to "filtered" list page through a goTo button
For instance, if you use http://localhost:8080/FluencyBuilder/FB_J_areas_list.jsp?filter_4_sel=0 -- the filter page will be chosen. I am not sure about applying the filter condition though, as I run into Nubmer Format Excepions for the filter_4_sel value.
In this way, you could set a goToButton to the page, and the first query could be set to return a null value.
Anyway, I think this is a consistent idea with dbforms navigation and also localWebEvent (conceptually as an idea --not directly in code). I think we should be able to 1) recognize user applied filters and 2) apply them later as desired in navigation and 3) be able to call a page with a preset filter (ie to produce a null set)
I am not sure just now how to impliment that but it's something I'd like to see done should I have the time or other developers have the interest.
In the meantime, I think I will try setting the sqlFilter attribute as a runtime attribute (initially setting the value to return a null set and then trying to 1) capture the users filter selection and 2) pass that filter selection (stored in session) in to the sqlFilter attribute for later pages --replacing the null value
--
Shawn
Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
