<CFQUERY DATASOURCE="#Attributes.DataSource#" NAME="NotSel" > SELECT DISTINCT #Attributes.ValueField# <!-- Only include Display field if attribute was specified --> <CFIF ParameterExists(Attributes.DisplayField) is "Yes"> , #Attributes.DisplayField# </CFIF> FROM #Attributes.ListTable# <CFIF ParameterExists(Attributes.SelectedItems) is "Yes"> WHERE #Attributes.ValueField# NOT IN (#PreserveSingleQuotes(Attributes.SelectedItems)#) </CFIF> <CFIF ParameterExists(Attributes.ListCondition) is "Yes"> <CFIF ParameterExists(Attributes.SelectedItems) is "Yes"> AND #PreserveSingleQuotes(Attributes.ListCondition)# <CFELSE> WHERE #PreserveSingleQuotes(Attributes.ListCondition)# </CFIF> </CFIF> </CFQUERY>