Ok i know this is simple but i have forgot something i want to limit the returned names on a select box to only those who have not signed up! <!--- Get the id of golfer EmployeeName [which is an ID] for limiting the drop down ---> <cfquery name="Get_Golf" datasource="golf"> SELECT GolfID, EmployeeName FROM tbl_Golf </cfquery> <!--- Find Employee Name for drop down :: But Hiding employees who have already signed up, with the where statement ---> <cfquery name="rs_Employees" datasource="golf"> SELECT EmployeeID, FirstName, LastName, Email FROM tbl_Employee WHERE #Get_Golf.EmployeeName# <> .EmployeeID ORDER BY LastName DESC; </cfquery> <!--- The Select Box in Question ---> <select name="Player2"> <cfloop query="rs_Employees"> <option value="<cfoutput>#rs_Employees.EmployeeID#</cfoutput>" <cfif (#rs_Employees.EmployeeID# EQ #rs_Employees.EmployeeID#)>SELECTED</cfif>><cfoutput>#rs_Employees.LastName# #rs_Employees.FirstName#</cfoutput></option> </cfloop> </select> Thank You! -paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
