use LIKE statement Ex: WHERE 1=1 <cfloop index="newsearch" list="#search#" delimiters=" "> OR (R like '%#newsearch#%') </cfloop>
R is your field in table yanton ----- Original Message ----- From: "list peters" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, 10 December, 2001 3:44 PM Subject: full text search > 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