Here are two sql statements that I use for a forums app. Both use multiple
columns:
SELECT TOP 300
ID,Name,Catagory,Description,TotalThreads,TotalTopics,IsPrivate,WebName,KeyW
ords,KEY_TBL.RANK
FROM Forums AS FT_TBL,
FREETEXTTABLE(Forums, *,'#SearchString#') AS KEY_TBL
WHERE FT_TBL.ID = KEY_TBL.[KEY] AND IsPrivate = 0
ORDER BY KEY_TBL.RANK DESC
SELECT TOP 300
FT_TBL.ID,
FT_TBL.Name,
FT_TBL.Body,
FT_TBL.TotalReply,
FT_TBL.Topic,
FT_TBL.DateCreated,
KEY_TBL.RANK
FROM Threads AS FT_TBL,
FREETEXTTABLE(Threads, *,'#SearchString#') AS KEY_TBL
WHERE FT_TBL.ID = KEY_TBL.[KEY] AND FT_TBL.IsArchived = 0 AND (SELECT
IsPrivate FROM Forums WHERE ID = (SELECT Forum FROM Topics WHERE ID =
FT_TBL.Topic)) = 0
ORDER BY KEY_TBL.RANK DESC
----------------------------------------------
Original Message
From: "PC"<[EMAIL PROTECTED]>
Subject: OT SQL 7 FULL-TEXT more than one column?
Date: Tue, 05 Sep 2000 12:44:52 -0700
>I know you can assign more than one column in setting up a fulltext index
>on a table -- but it seems like you can't include more than one column in
>the where CONTAINS statement...if this is indeed true how do you create a
>query to search thru all of the columns you have included in the fulltext
>indexing of a given table? An example would be highly appreciated!
>
>TIA
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
_____________________________________________
Free email with personality! Over 200 domains!
http://www.MyOwnEmail.com
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
