thanks Alistair.
but i just did this, it may be way wrong.
it works but if you know it is bad, please let me know
<!--- Get the id of golfer EmployeeName for limiting drop down --->
<cfquery name="Get_Golf" datasource=#MM_golf_DSN#
username=#MM_golf_USERNAME# password=#MM_golf_PASSWORD#>
SELECT DISTINCT EmployeeName
FROM tbl_Golf
GROUP BY EmployeeName
</cfquery>
<CFQUERY NAME="rs_Employees"
DATASOURCE="#MM_golf_DSN#"
DBTYPE="ODBC">
SELECT FirstName, LastName, Email, EmployeeID
FROM tbl_Employee
WHERE EmployeeID NOT IN (<cfloop query="Get_Golf">
<CFOUTPUT>#Get_Golf.EmployeeName#,</CFOUTPUT>
</CFLOOP>)
ORDER BY LastName
DESC;</CFQUERY>
<select name="Player4">
<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>
FweeeeW!!!! man what a day :]
thanks again
-paul
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists