why not do this 1. Query a verity collection, return the results as "key, title, body" (also get back a score)
2. Query a 2nd verity collection, return the results as "key, title, body" (also get back a score) <cfquery > SELECT * FROM Query1 UNION SELECT * FROM Query2 order scores desc </cfquery> WG -----Original Message----- From: Jeff [mailto:[EMAIL PROTECTED] Sent: 22 August 2003 15:23 To: CF-Talk Subject: Arrrgh, this is driving me crazy, and I know it's so simple to do... 1. Query a verity collection, return the results as "key, title, body" (also get back a score) 2. Query a 2nd verity collection, return the results as "key, title, body" (also get back a score) 3. Create a structure to hold the results. 4. Create an Array to hold the structure. 5. Loop over the first set of results, storing everything AND the score in the struct, then storing that as an entry in the array 6. Loop over the second set of results storing everything AND the score in the struct, then storing that as an entry in the *SAME* array. 7. Now I should have an array that has a structure containing a key, a title, a score and a body for each result (it's not a lot of information, just a string). 8. Sort the array by the score, combining the results of both collections and outputting them with the high scores at the top (naturally). Is that so hard to do? Am I thinking of it wrong? Is my approach somehow wrong? Each collection (and once I figure it out for two collections, there will be MANY collections eventually added) contains a small amount of data that will need to be displayed differently, depending on which collection it came from. I want to *present* the results, sorted by score as "one" result, but each link will be passing a variable that will determine how it's displayed on the following linked page. Make sense? That's why I can't just search a bunch of collections, because *which* collection the result came from will determine how it's going to be displayed. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
