[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