This is an old problem that effects all forms
My approach would be to divide and conquer,
1. Create an application scope bean for each country containing geographic
data about that country
2. On the first page of your JSP make the user pick a country (hardcoded in
JSP since countries don't change much) and then click submit, this takes you
to the next page
3. On the next page access the relevant country bean and populate drop-downs
with bean data.
For large countries you may choose to divide again, e.g. for the USA you may
have beans for individual states, note that
if you update the backend DB data it won't be reflected in the bean until
it's re-instantiated
Glenn
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
