Dear All, I'm in this situation.
I need a form that lists personal information about a lot of people....
I created a filter that filters the data on the year of birth of a person,
but the time spent by the system the first time it load the form (displaying all
the information) is very long.
So I wanna put a "default" filter on the year of birth of the persons that than
the user can change...
For example now I tried to put the filter on dbfrom tag plus the dbfilter tag,
but the former is TOO static and it's impossible for the user to change the
filtering criteria.
Well you could define the filter on dbform tag to be your default like:
String default =dob="1/1/2000";
if (request.getParameter("year_of_birth)!=null){ myfilter="dob="+(request.getParameter("year_of_birth"); }else myfilter=default;
Then set a goToButton to navigate to the current record. And then set a field in your form to allow user input <textarea name="year_of_birth"></textarea> or some such way
And I think you would have a default filter that allowed user input.
It's kinda a work around and it would be great if someone altered the dbfilter to allow for a default setting. I am tied up at least until ther third week of June though so couldn't do it until then at least and well no promises...
Shawn
--
Happily using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g. Take an Oracle 10g class now, and we'll give you the exam FREE. http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
