Hi We tried this but it didn't seem to work. We only changed the english one. When we search on these key words it still throws an ODBC error. Any ideas?
Andy -----Original Message----- From: Benoit Hediard [mailto:[EMAIL PROTECTED]] Sent: 11 October 2002 13:23 To: CF-Talk Subject: RE: Full Text Indexs If you are using SQL Server 2000, all the "noise words" are defined in a text files, one per language, you can easily modify them (add/remove words) : "../Microsoft SQL Server/MSSQL/FTDATA/SQLServer/Config/noise.eng" for english indexing "../Microsoft SQL Server/MSSQL/FTDATA/SQLServer/Config/noise.fra" for french indexing . Once modified, you'll have to rebuild your full-text indexes. Benoit Hediard www.benorama.com -----Message d'origine----- De : Andy Ewings [mailto:[EMAIL PROTECTED]] Envoy� : vendredi 11 octobre 2002 14:00 � : CF-Talk Objet : Full Text Indexs Bit OT but thought I'd test the SQL gurus on here - I have built some full text indexes and am trying to get it to ignore the "ignored" words if that makes sense. For exaple if I type "after eight" into a search box it gives an error as "after" is a reserved word. How to I get SQL to ignore these words when performing my fulltext query? Alternatively does anyone know where I can find a full list of these ignored words? Andy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
