Howdy oh-great-list, I am trying to populate a multiple select that is dynamic. One query holds the select options and another holds the list of values currently in the database.
For example: Query A gets all users and populates the dynamic select with Susy Bill Allan Phillip Query B returns results from another table indicating that Allan and Phillip were selected last time so I want to pre-select them. My issue is getting the dynamic select CFIF statement to populate. I currently have... <!-- Query to populate select --> <cfquery name="QueryB" datasource="db"> SELECT UserID,FirstName,LastName FROM Users WHERE Users.ProgramNumber = '#session.ProgramNumber#' </cfquery> <!-- Query of Curently selected users --> <cfquery name="QueryB" datasource="db"> SELECT * FROM Users_to_files WHERE FileID = '#URL.File#' </cfquery> ..and I can't get beyond building the standard select... <select name="MemberList" selected="Select..." tabindex="1" size="15" MULTIPLE> <cfoutput query="QueryA"> <OPTION value="#UserID#">#FirstName# #LastName#</OPTION> </cfoutput> </select> ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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
