I can see your problem, but I will need the rest of the code with the quesries in it too finish the job, the problem is that you will need to loop through the entire second query and comparing the values :-) The way it is at the moment its not moving onto the second record of the second query:-) -----Original Message----- From: S.E.Fling [mailto:[EMAIL PROTECTED]] Sent: 02 August 2000 14:05 To: [EMAIL PROTECTED] Subject: Multiple Select problem H alli, I'm trying to display multiple selected values in a drop down list box, but can't figure out to select multiple values programmatically. These values are returned as WorkLocationCountryCode by the query qrySelectCountry, and 5 rows are returned. qryAllCountries returns all the countries, and as the drop down is populated, each value is tested against the 5 values. The problem is, only the last value evaluated is selected in the DDLB. Manually you would hold the Ctrl or Shift key to select multiple values, but how do you do it within an output query? <cfselect name="SelectCountry" size="23" required="Yes" multiple> <OPTION VALUE = "ALL">ALL Countries <cfoutput query="qryAllCountries"> <CFIF #WorkLocationCountryCode# EQ #qrySelectCountry.WorkLocationCountryCode#> <OPTION VALUE="#WorkLocationCountryCode#" selected>#Country# <cfelse> <OPTION VALUE="#WorkLocationCountryCode#">#Country# </CFIF> </CFOUTPUT> </OPTION> </CFSELECT> I'd appreciate any tips, clues or suggestions. Many thanks! sf ---------------------------------------------------------------------------- -- Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
