Drop Down List not sorting correctly
Hi,
I have a query that I use in a drop down form. NOMEN.GENERIC_NOMEN is the values that I want displayed in the drop down
While the value I want to select is NOMEN.NOMENCLATURE_ID.
Here is the underlying Query (notice it is sorted by the form values that I want to display)
<cfquery name="NOMEN" datasource="ilmf_parts_dev" blockfactor="100">
SELECT *
FROM NOMEN_TABLE
ORDER BY GENERIC_NOMEN ASC
</cfquery>
Here is the code for that part of the form:
<td width="96" class="style1">Nomenclature</td>
<td width="379" class="style1"><cfselect name="Add_Inv_Nomen">
<cfoutput query="NOMEN">
<option value="#NOMEN.NOMENCLATURE_ID#">#NOMEN.GENERIC_NOMEN#</option>
</cfoutput>
</cfselect> </td>
For some reason, the drop down displays the text in the order of the table index instead of alphabetically in ASC order.
Any Ideas?
Eric
Ps Running off of Oracle 11g DB.
