cant work out syntax error, please help

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

cant work out syntax error, please help

Author

Topic

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-04-01 : 07:33:06

SELECT FT_TBL.Record_Pointer, KEY_TBL.RANK, FT_TBL.Keywords
FROM Contact AS FT_TBL INNER JOIN
CONTAINSTABLE(Contact, Keywords, 'ISABOUT (visual (.8), windows (.4), qbasic (.2) )' ) AS KEY_TBL
ON FT_TBL.Record_Pointer = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC

give me:

Server: Msg 7631, Level 15, State 1, Line 1
Syntax error occurred near '('. Expected '',', ')'' in search condition 'ISABOUT (visual (.8), windows (.4), qbasic (.2) )'.

rfrancisco
Yak Posting Veteran

95 Posts

Posted - 2005-04-01 : 09:30:58

You forgot the keyword "WEIGHT":

'ISABOUT (visual weight (.8), windows weight (.4), qbasic weight(.2) )'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources