[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 ft_tbl, peepers 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: Marlon Moyer
To: CF-Talk
Sent: Sunday, February 15, 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:[EMAIL PROTECTED]
> Sent: Sunday, 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 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]
