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

Mark Groen evolt at markgroen.com
Tue Aug 15 09:25:44 CDT 2006


On Tue, 2006-08-15 at 08:57 -0500, Casey Crookston wrote:
> >>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.<<
> 
> Yup tried that: Line 5: Incorrect syntax near '+'.
> 
> I am 100% astounded that I can't find the solution on Google.  Has
> NOBODY ever had this problem before?

Don't know much about MS SQL, but a quick scan of the specs here:

http://msdn2.microsoft.com/en-us/library/ms177652.aspx

and a little read through this article:

http://www.databasejournal.com/features/mssql/article.php/3454281

methinks your single quotes nested inside other quotes may be a problem, also, missed the first part of this thread so although it says the syntax error is near the +, it could be related to something further up the query?
Perhaps repeating the entire query may make a light bulb go on for someone...
-- 
cheers,

        Mark




More information about the thelist mailing list