Maybe you have a problem with your full-text index. You can rebuild in Enterprise Manager to eliminate as a possibility:
>From BOL: Expand a server group, and then expand a server. Expand Databases, and then expand the database that contains the full-text catalog to rebuild. Click Full-Text Catalogs, and then right-click the specific catalog to rebuild. Select Rebuild Catalog. Click Yes to rebuild the catalog. Glenn Olsen Macromedia Certified Advanced ColdFusion Developer ----- Original Message ----- From: "Andy Ewings" <[EMAIL PROTECTED]> Newsgroups: cf-talk Sent: Wednesday, August 21, 2002 6:52 AM Subject: RE: SQL indexes > Yeh I know - actually it doesn't seem to make a blind bit of difference - > get the same records back > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 21 August 2002 11:51 > To: CF-Talk > Subject: Re: SQL indexes > > > > SELECT dc.* > > FROM DOCUMENT_SEARCH dc > > WHERE CONTAINS(dc.title, ' "*cowboy*" ') > > contrary to normal sql, the full text functions want "*" as wild & search > phrases contained in ""(double quotes). > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
