I have this query:
<cfquery name="disprepstatus" datasource="SPMS">
SELECT *
FROM disprep
</cfquery>
I'm using this List/Menu drop-down:
<select name="disprepstat" size="1">
<cfoutput query="disprepstatus">
<option
value="#disprepstatus.disprepID#">#Trim(disprepstatus.disprepstatus)#</optio
n>
</cfoutput>
</select>
How can I get the value already in the record to come up? It's currently
defaulting to 1 and I have up to 60 different choices.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
