Dynamic Drop Down Menu

Hi,

I am trying to create a drop down menu, that will allow a user to select entries from another table (Like a look-up field in Access).

This is the code I am using.

<CFOUTPUT QUERY="empList">
<select name="select">
<option>#applicationid#, #application_name#</option>
</select>

</CFOUTPUT>

My problem is that instead of displaying the data in a nice drop down menu, it makes me a new drop down menu for each entry (See screenshot)

URL

I'm very new to Coldfusion, just doing it for a Uni project. If anyone can help me I would be very grateful.

Regards
Ian Harrison

The problem is that you have placed <select> tags inside loop.


Correct code:

<select name="select">
<CFOUTPUT QUERY="empList">
<option>#applicationid#, #application_name#</option>
</CFOUTPUT>
</select>

Brilliant, worked perfectly.

Thanks for taking the time to answer, saved me lots of stress!