Unless I miss what you're asking, this works for me:
<cfquery name="MyQuery">Do Your Query</cfquery>
<select name="MySelect">
<option>Here's a default display if you want it</option>
<cfoutput query="MyQuery"><option
value="#WHATEVER#">#DISPLAY#</option></cfoutput>
</select>
You'll want to do some error checking to make sure they select a value on
submit or give the default selection a default value.
Ken
--you coulda walked upstairs and asked me :)
> Does anyone have any sample code for making database driven dynamic select
> boxes? I have tried following the three powerpoint slides that were in
> Nat's presentation, but I just can't seem to get it.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
