Try this Paul...
<CFSET Types_ID = ValueList(edit.Consultant_Types_ID)>
<select name="Consultant_Types_ID" size="3" multiple>
<CFOUTPUT QUERY="rs_Consultant_Types">
<option
value="#rs_Consultant_Types.Consultant_Types_ID#"><cfif
ListFindNoCase(Types_ID,
rs_Consultant_Types.Consultant_Types_ID)>SELECTED</CFIF>>#rs_Consultant_Type
s.Consultant_Types_Name#</option>
</CFOUTPUT>
</select>
Frank
-----Original Message-----
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 26, 2001 8:57 AM
To: CF-Talk
Subject: Updating a multiple select box dynamically. question?
Hello all.
i have a update page that has a Multiple Select box that i want to be able
to dynamically up date.
now if there has only been one prior selection, then it shows up in the
update select box.
but if there has been more then one selection made, then nothing shows up.
i hope you know what i mean!
any help would be great!
thanks
-paul
<select name="Consultant_Types_ID" size="3" multiple>
<cfloop query="rs_Consultant_Types">
<option
value="<cfoutput>#rs_Consultant_Types.Consultant_Types_ID#</cfoutput>"
<cfif (#rs_Consultant_Types.Consultant_Types_ID# EQ
#edit.Consultant_Types_ID#)>SELECTED</cfif>>
<cfoutput>#rs_Consultant_Types.Consultant_Types_Name#</cfoutput></option>
</cfloop>
</select>
-paul
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
