anchor.diff:  	<cfoutput>
   		<!---- first get the terms that match our search ---->
   		<cfquery name="dc0" datasource="uam_god">
  -			select nvl(parent_tid,0) parent_tid, term,tid,rank from hierarchical_taxonomy where upper(term) like '#ucase(q)#%'
  +			select distinct nvl(parent_tid,0) parent_tid, term,tid,rank from hierarchical_taxonomy where upper(term) like '#ucase(q)#%'
   		</cfquery>
   		<p>
   			init query:
  
positive.code: 			<cfquery name="q" datasource="uam_god">
  				select nvl(parent_tid,0) parent_tid, term,tid,rank from hierarchical_taxonomy where tid in (#thisIds#)
  			</cfquery>
  			<cfdump var=#q#>
  
  			#i#
  		</cfloop>
  
  	<cfquery name="d" datasource="uam_god">
  		select nvl(parent_tid,0) parent_tid, term,tid,rank from hierarchical_taxonomy where parent_tid is null
  	</cfquery>
  
negative.code: 	<cfset x=x & "]">
  
  		<cfreturn x>
  		--------->
  	</cfoutput>
  
  </cffunction>
  