[thelist] MS SQL Using 'FormsOf(INFLECTIONAL, ) in a full-text search

jason.handby jason.handby at corestar.co.uk
Tue Aug 15 01:57:37 CDT 2006

Hi Casey,
I think you need to adjust your quotes. Something like this:
  FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, ' + @search + ')' )
In other words you need to splice @search into the string using + I think.


From: thelist-bounces at lists.evolt.org on behalf of Casey Crookston
Sent: Mon 14/08/2006 23:18
To: thelist at lists.evolt.org
Subject: Re: [thelist] MS SQL Using 'FormsOf(INFLECTIONAL,) in a full-text search

More specific:

FREETEXTTABLE(listings, *, 'FormsOf(INFLECTIONAL, @search')

It always treats @search as NULL. What's wrong with my syntax here?




* * Please support the community that supports you.  * *

For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !

More information about the thelist mailing list