----- Original Message -----
From: Philip Arnold
To: CF-Talk
Sent: Sunday, February 15, 2004 8:08 PM
Subject: RE: SQL Freetext
I'm presuming you're using SQL Server
Why aren't you using CONTAINS()? It's a lot easier to read than using
the FREETEXTTABLE() function IMO
> -----Original Message-----
> From: admin [mailto:[EMAIL PROTECTED]
> Sent: 15 February 2004 19:22
> To: CF-Talk
> Subject: sot: SQL Freetext
>
>
> Just wondering if any one has some examples of how I can do
> the following.
>
> I need to do a freetext search on two tables and return the
> selections by rank - this is what I came up with but of
> course gets a syntax error (no sql manual around today !) -
> any suggestions would be much appreciated.
>
> SELECT name,
> FROM table1 as ft_tbl,
> table2 as ft_tbl2
> INNER JOIN
> freetextTABLE (table1,*,'widget',100) AS KEY_TBL ON ft_tbl.ID
> = KEY_TBL.[KEY], INNER JOIN freetextTABLE
> (table2,*,'wifget',100) AS KEY_TBL2 ON ft_tbl2.ID =
> KEY_TBL2.[KEY] ORDER BY KEY_TBL.RANK, namet asc
>
> Cheers
>
> Richard
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
