
August 29th, 2003, 09:29 AM
|
|
Moderator
|
|
Join Date: Jun 2002
Location: Raleigh, NC
|
|
|
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>
|