----- Original Message ----- > You can run a verity search on more than one collection at a time. That > way, the results will already be properly sorted.
Yeah, but here's the thing. The tables hold data that can be stuck into "key, title, body" columns, but the display of each column is different, so each collection will be displayed differently, thus the "custom1" column in my cfsearch. I want to mix the results for display purposes, showing scores correctly ranked when mixed, but I want to display the results differently. My solution was to search each collection, place the results into a structure of some sort, including the "custom1" column that will determine how to display the data on the details page, and sort them all by "score" so that output results are "sorted" by "score" yet their "colum1" information will determine how the data is displayed on the following page. Make sense? So *can* you do that? stick each result set into some sort of data structure for each query returned, then sort that structure, ordering by "score", then outputting the results? For instance, collection 1 returns the following: Score - Title (custom1) 97 - My New Title (1) 67 - A Second Title (1) 78 - The Fifth Title (1) And collection 2 returns the following: 86 - The Title of This Document is This (2) 76 - I'm Titling This Document Thusly (2) 23 - A Whimsical Title To Enjoy (2) Then my output is as follows: 97 - My New Title (1) 86 - The Title of This Document is This (2) 78 - The Fifth Title (1) 76 - I'm Titling This Document Thusly (2) 67 - A Second Title (1) 23 - A Whimsical Title To Enjoy (2) See? Then, when you clicked the link, you'd know *which* collection passed you the results...then you could display it appropriately, if it needs to be displayed differently (which mine does). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com
