[thelist] MS SQL Using 'FormsOf(INFLECTIONAL, ) in a full-text search
Chris Marsh
thelist at cjmarsh.com
Wed Aug 16 09:13:40 CDT 2006
Casey
> Solved.
>
> DECLARE @SearchWord nvarchar(4000)
> SET @SearchWord = 'tax'
> EXEC('SELECT listing_id, RANK, name, address, city, zip,
> heading, phone
> FROM listings a,
> FREETEXTTABLE(listings, *, ''FormsOf(INFLECTIONAL, '+
> @SearchWord +')''
> )
> WHERE [KEY] = a.listing_id
> ORDER BY RANK DESC, name')
You've solved the issue of the error that you were experiencing, but it may
be worth checking your results. As I pointed out, the documentation
specifies that FORMSOF cannot be used as the free_text parameter with
FREETEXTTABLE. Are you 100% sure that FORMSOF is being processed, and not
simply being treated as a string? I would personally be wary of using
behaviour that differs to the behaviour stated in the documentation, as
apart from anything else this may be "fixed" in later versions; breaking
your application.
FWIW, HTH.
--
Regards
Chris Marsh
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.10.10/419 - Release Date: 15/08/2006
More information about the thelist
mailing list