Using FREETEXT and noise words

[DomTrix]

Ok, having got over the irritation of SQL throwing an error when the search string passed to FREETEXT contains only noise words, I want to be able to handle that error so that my application does not receive it.


I tried:

...
BEGIN TRANSACTION
    SELECT * FROM myTable
    INNER JOIN FREETEXTTABLE(myTable,*,@searchString) as ftTable
    ON myTable.[key] = ftTable.[key]
    ORDER BY ftTable.RANK

    SET @error = @@error
    IF @error != 0
        BEGIN
            ROLLBACK TRANSACTION
            RETURN 0
        END
...

But the error is still returned to the app (a ColdFusion web page).

Do I have to handle this error application side or is there a way to handle it from the database?

Thanks in advance

DT

 

[mrdenny]

You'll have to handle this on the client side.

The other option would be to remove the noise words from the noise words file. This would turn a freetext search for "a and the" into a valid search (assuming you chose to remove these from the file).

I've used this to work around a specific problem in the past, and it worked well.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[DomTrix]

Ty