can 'contains'be used to span multiple fts catalogs and return rows and ranks ?
- 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
can 'contains'be used to span multiple fts catalogs and
return rows and ranks ?
To be honest, I don't know, as I always use FTS on one field and search
just for that, returning in an order that I require...
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User
AFAIK CONTAINS on its own cannot span...have you investigated what the
Microsoft Search service can do for you?
From: Philip Arnold [mailto:[EMAIL PROTECTED]
Sent: 17 February 2004 13:05
To: CF-Talk
Subject: RE: SQL Freetext
can 'contains'be used
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.
will remember
Teach me and I will learn
-Original Message-
From: admin [mailto:[EMAIL PROTECTED]
Sent: Monday, 16 February 2004 10:22 AM
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
for two I get the standard syntax error
[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'INNER'.
- Original Message -
From: Taco Fleur
To: CF-Talk
Sent: Sunday, February 15, 2004 4:26 PM
Subject: RE: SQL Freetext
What's the error you are getting?
Did you
Kevin
-Original Message-
From: admin [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 7:07 PM
To: CF-Talk
Subject: Re: SQL Freetext
yep catalogs are created and I can do a freetext search on just one :-
SELECT rank,id,name,instructions
FROM recipes as ft_tbl
INNER JOIN
-
From: Kevin Webb
To: CF-Talk
Sent: Sunday, February 15, 2004 6:11 PM
Subject: RE: SQL Freetext
I have not done any full text search like you have, but I did notice
that there is a comma after the first INNER JOIN.I have written many
queries with joins and have not used a comma after
, February 15, 2004 8:55 PM
To: CF-Talk
Subject: Re: SQL Freetext
Way to go kevin ! I didn't see that now at least I get a decent error
message - of course I'm now even more confused !
[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'ft_tbl'
does not match with a table name
, 2004 7:20 PM
Subject: RE: SQL Freetext
Remove the as from cjprod as ft_tbl and peepers as ft_tbl2
--
marlon
And Bobby you are right, I am being selfish, but the last time I checked,
we don't have a whole lot of songs that feature the cowbell!
-Original Message-
From: admin [mailto
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
11 matches
Mail list logo