So, what's your problem. You said what you'd like to do, you showed your
code, what's not working?
-----Original Message-----
From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 6:13 AM
To: CF-Talk
Subject: Select Boxes <> limiting drop down :: Brian Lock
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
