display query in selection

[mkauspe]

I want to create a drop down, or selection list with a query from a db. Can
anyone give a hint or explain how to do this? I tried cfselect but can't get
the data to display.

The value of the attribute Query, which is currently "qwe", is invalid.

Here's the code, <cfselect query="#display_all.make#" name="selection"
visible="yes"></cfselect>

It actually reads the data from the db, but will not display it. I tried
mutiple columns. Thanks!!

yes I an a n00b :)

[mkauspe]

I figured it out

<cfselect name="delete">
<option value="Select an item"</option>
<cfoutput query="display_all">
<option value="#model#">#model#</option>
</cfoutput>
</cfselect>

[The ScareCrow]

An easier way

<cfselect name="delete" query="display_all" queryposition="below" value="model" display="model">
<option value="Select an item"</option>
</cfselect>


Ken