Dependent drop down lists

[rock123]

I need to develope a search screen that has drop down lists. These drop down list choices are dependent, i.e. the
choices of the second list are dependent on what the user chooses from the first list.

I want to populate second list from database(oracle).
I am generating html pages using oracle pl/sql.

Is there any way to fetch data from database and store it in a javascript arrays ?


Can't find info on how to do this, do you have any idea where I may be able to find any examples or decent documentation.

[khalidali63]

you should be able to do this using any programming language(Java?).
Once you have retrieved the data from the db then creating a webcomponent should be fairly easy.
here is an example of multiple dropdown boxes,where second one is populated depending upon the choice from the first.
http://68.145.35.86/skills/javascripts/MultipleListBoxResult3rdListBox.html

For database stuff with java look here.

http://java.sun.com/docs/books/tutorial/jdbc/index.html

Hope this helps

Cheers

Khalid

[rock123]

Hi Khalid

Thanks for your reply.

Unfortunately if i click the example link it comes back with page not found error.

Regards