[Microsoft][ODBC SQL Server Driver][SQL Server]The column prefix 'ft_tbl' does not match with a table name or alias name used in the query.
SQL = "SELECT name,description,rank,sku,price,IMAGEURL FROM cjprod as ft_tbl,peepers as ft_tbl2 INNER JOIN freetextTABLE (cjprod,*,'pasta',100) AS KEY_TBL ON ft_tbl.ID = KEY_TBL.[KEY] INNER JOIN freetextTABLE (peepers,*,'pasta',100) AS KEY_TBL2 ON ft_tbl2.ID = KEY_TBL2.[KEY] ORDER BY KEY_TBL.RANK DESC, price asc"
----- Original Message -----
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 an inner join. that
is probably your issue.
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], -- <-- DELETE COMMA THAT IS
HERE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
INNER JOIN
freetextTABLE (table2,*,'wifget',100) AS KEY_TBL2 ON ft_tbl2.ID =
KEY_TBL2.[KEY]
ORDER BY KEY_TBL.RANK, namet asc
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
freetextTABLE (recipes,*,'#class#',100) AS KEY_TBL
ON ft_tbl.ID = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK desc
and it works great but with the code I wrote 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 actually create the full-text catalog on the columns?
Taco Fleur
Blog <http://www.tacofleur.com/index/blog/>
http://www.tacofleur.com/index/blog/
Methodology http://www.tacofleur.com/index/methodology/
Tell me and I will forget
Show me and I 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 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]
