Ick. I really dislike embedding CFML tags inside HTML tags. I think it makes
it too hard to read.
Another way is:
<option value="#disprepID#" #Iif(the_current_value eq
disprepID,DE("selected"),DE("")#>#Trim(disprepstatus.disprepstatus)#</option
>
For maximum readability:
<cfoutput query="disprepstatus">
<cfif the_current_value eq disprepID>
<cfset selected="selected">
<cfelse>
<cfset selected="">
</cfif>
<option value="#disprepID#"
#selected#>#Trim(disprepstatus.disprepstatus)#</option>
</cfoutput>
> -----Original Message-----
> From: Phillip Cave [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 13, 2003 9:19 AM
> To: CF-Talk
> Subject: RE: Default List/Menu
>
>
> You can do:
>
> <select name="disprepstat" size="1">
> <cfoutput query="disprepstatus">
> <option value="#disprepID#" <cfif
> the_current_value eq disprepID>
> selected </cfif>>#Trim(disprepstatus.disprepstatus)#</option>
> </cfoutput>
> </select>
>
> Where 'the_current_value' is the value in your record.
>
> Phillip
>
> -----Original Message-----
> From: "Hawkes [mailto:"Hawkes]
> Sent: Thursday, February 13, 2003 10:00 AM
> To: CF-Talk
> Subject: Default List/Menu
>
>
> 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.dispreps
> tatus)#</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
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
