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

[jason.handby]

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.
 
 
HTH
 
 
 
Jason

________________________________

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?

Thanks!

Casey


--

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

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