search problem

[robmar]

Barry - tried a search for "K AND cambelt" and got the following error

 

Microsoft OLE DB Provider for SQL Server error '80040e14'

 

Execution of a full-text operation failed. A clause of the query contained only ignored words.

 

/Searchsp.asp, line 112

 

 

I was searchinng all of techtallk from the mists of time

 

rob

[Site Manager]

Hi Rob,

 

I think you need to speak to your colleagues

 

SQL Server 2000 full text searching doesn't index single letters, which is why, just under the search box there is:

However, single letters or numbers are not put into the search database, so there's no point searching for '7' or 'k' for instance

What's happening in this particular search is that the script is creating two clauses eg extract all items where [contains "k"] and [contains "cambelt"]. One of the clauses therefore, [contains "k"], being a single letter, is an ignored word and so the error arises.

 

I'll put some validation on the search box to reject single letter criteria.

[robmar]

doh 😬 youu mean I have to read the instructions

 

thanks