Hi Maureen, Many thanks for the reply.
Taking the first two queries. In Product I search on title, short description and long description. In Product Options I search on the option title and description. I tried some tests joining the tables:- <cfquery dbtype="query" name="product"> select stockID from stockTable left outer join stockItemsTable ON stockItemsTable.stockID = stockTable.stockID </cfquery> I assume I need to use a left outer join. Although the stocktable and stockitemstable individually returned results, I can't get the combined tables to produce anything. As I understand it FREETEXTTABLE can only search on one table at a time? I can't use a database view in the fulltext catalogue? If I can it answers all my problems. Jenny -----Original Message----- From: Maureen [mailto:mamamaur...@gmail.com] Sent: 24 April 2011 00:26 To: cf-talk Subject: Re: Problem Using QueryNew Seems to me it would a lot more efficient to make a view in your database that only returns the two fields you want to search on plus any fields you need for search criteria. Or do a select with a join that returns the fields. Once you do that, they are already in a query, so you wouldn't need to make another query to hold them. On Sat, Apr 23, 2011 at 4:21 PM, Jenny Gavin-Wear <jenn...@fasttrackonline.co.uk> wrote: > > Many thanks, Will. Obvious now I look at it again, duh me. > > Anyhoo, I had this (probably dumb) idea of combining sever fulltext search > query results into one table, turning into a lot more work than I expected > (+ learning curve). > > Maybe there is a better way of going about this: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:343922 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
