hi... i have setup a full text search and have been searching happily...
but not getting errors if i search for 2 words.... how can i change this: WHERE CONTAINS(r.*, '"#search#%"') to do and OR search. something like ?? WHERE CONTAINS(r.*, ' <cfloop index="newsearch" list="#search#" delimiters=" "> "#newsearch#%" OR </cfloop> ') i cant get it write.... and to change from and to or search can i just change the operator from "and" to "or" and vice versa? thanks chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
