Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Not Returning any records using CONTAINSTABLE
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

redbrad0
Advanced Member

USA
3725 Posts

Posted - 27 January 2005 :  16:08:04  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
The following Query is not returning any results...

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


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

SELECT     RSSFeedsData_Data
FROM         RSS_Feeds_Data Data
WHERE     (RSSFeedsData_Data LIKE '%height%')


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

RSSFeedsData_ID           int
RSSFeedsData_FeedID       int
RSSFeedsData_Data         text
RSSFeeds_Error            nvarchar(500)
RSSFeedsData_DateArchived nvarchar(20)

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets

-gary
Development Team Member

406 Posts

Posted - 28 January 2005 :  23:37:47  Show Profile
Is your table indexed and the index up to date?

KawiForums.com


Go to Top of Page

redbrad0
Advanced Member

USA
3725 Posts

Posted - 31 January 2005 :  00:16:09  Show Profile  Visit redbrad0's Homepage  Send redbrad0 an AOL message
awww your correct again. I have now set it on a schedule

Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000 Version 3.4.07