Hello

I am currently creating an order form jsp page which contains a form.

This form has several drop down menus - with one of them intending to read the contents of a database table which contains information.

The database is set up and is ready to populate the drop down menu, however, I am having trouble in making JSP understand what I would like it to do.

I have in the JSP page code that explains where the database is and what table and fields I would like to use.

Then on the drop down menu I have again posted code to explain JSP to look up the database however, when the page is run, only one option is available.

Does anyone know of any tutorials or anyone know what is going wrong could you please let me know. I will post snippets of my code if it will help letter on today.

Many Thanks

Mike