[Opensource] jsp question

[Nghia.G.Phan at kp.org]

Hi:
   Thank you for code. However, we have a different problem. 
    First, we cannot hard code our data in the neither Javascript (html 
file) nor in the JSP page. Second, because of this, we need to access to 
database to load a new value to the another combo based on the selected 
value of the previous combo and the login user's profile.
   Our problem is not only because we have thousands of data values (not a 
good idea for hard-code and the list keeps growing) but we have to go thru 
several variables (combo's value, user's profile, etc...) before we are 
able to determine the new value to show on the next combo.
   As an example: first Combo shows Medical Centers, which contains at 
least twenty of them.
                                  The second Combo shows Departments, 
which are more than thousand of them. 
                                     The Department is selected based on 
Medical Center and user's profile.
                                  The third Combo shows Providers, which 
have about 10 thousands. The Provider is 
                                      selected based on Department and 
user's profile.
   what do you think about our problem? What is a good way to solve it?
   Thank for your help!
Nghia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.jcorporate.com/pipermail/opensource/attachments/20020619/e6d5d4b2/attachment-0002.htm