dynamic drop down list for CF

Im trying to get a drop down list to dynamicaly pull distinct categorys from a database to a drop down, any ideas on how to do this?

Thanks

Same problem occured with me! Its not working in IE for CE!

Anyone have a way to over come it?

Unless I'm missing something, this is really easy to do:

<cfquery name="myQuery">
select distinct categoryID, categoryName
from categories
</cfquery>

<form>
<select name="categoryid" size="1">
<cfoutput query="myQuery">
<option value="#myQuery.categoryID#">#myQuery.categoryName#</option>
</cfoutput>
</select>
</form>

thank you for your help