It would be much better to say
WHERE EmployeeID NOT IN (#QuotedValueList(Get_Golf.EmployeeName)#)
|-----Original Message-----
|From: Paul Ihrig [mailto:[EMAIL PROTECTED]]
|Sent: Thursday, May 31, 2001 12:48 PM
|To: CF-Talk
|Subject: RE: Select Boxes <> limiting drop down :: Please Look
|
|
|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_Employ
|ees.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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
