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:343919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm