You can combine the two returned queries with a UNION. SELECT col1, col2, etc FROM searchQuery1 UNION SELECT col1, col2, etc FROM searchQuery2
Adrian -----Original Message----- From: John Barrett [mailto:[EMAIL PROTECTED] Sent: 01 September 2008 06:52 To: CF-Newbie Subject: verity I have a general question about using verity: Is it possible to search a collection that will search a collection for text on certain web pages in that collection, and search database results at the same time,and display the results? That is if you search something like "ColdFsuon" the search would search text & database at same time and return the results? Is this a common task in CF with verity? I have two searches, one using verity which searches for text,a nd another one searching db query, but I want to combine the two. If anybody knows of an on-line example that shows this I would like to see. Thanks so much, John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3955 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
