Post reply

Not Returning any records using CONTAINSTABLE

  • January 27, 2005 at 5:08 pm

    #92214

    The following Query is not returning any results...

    SELECT     Data.RSSFeedsData_Data, WEIGHT.RANK AS RSSFeedRankingFROM         RSS_Feeds_Data Data INNER JOIN                      CONTAINSTABLE(RSS_Feeds_Data, RSSFeedsData_Data, 'ISABOUT ("height")') WEIGHT ON Data.RSSFeedsData_ID = WEIGHT.ORDER BY WEIGHT.RANK DESC

    But if I use this query it does return the results..

    SELECT     RSSFeedsData_DataFROM         RSS_Feeds_Data DataWHERE     (RSSFeedsData_Data LIKE '%height%')

    Anyone have a idea why it is not returning any results? Below is my table structure..

    RSSFeedsData_ID           intRSSFeedsData_FeedID       intRSSFeedsData_Data         textRSSFeeds_Error            nvarchar(500)RSSFeedsData_DateArchived nvarchar(20)

  • January 31, 2005 at 2:20 pm

    #539802

    did you create a full-text-index ?

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply