Hi Maureen, I found it is possible to create indexed views and add them to a fulltext catalog, however, among a longgg list of constraints MS say that the views cannot contain Ntext fields, which rules out that option for me.
http://msdn.microsoft.com/en-us/library/aa933148%28v=sql.80%29.aspx -----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:343930 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm