At 06:43 PM 8/21/2003 -0400, you wrote: >Let's say I query two collections. I know for each collection from a >Table, I'll be getting #key#, #title#, #custom1#, #body#. I also know I'll >be returning "Score" as well, and I'd like to somehow combine the query >results and output them sorted by score. That way, the output, which would >be identical: >#score# - <a href="details.cfm?id=#key#>#Title#</a><br> >would be ordered by "score". > >Can you put them in a struct, then somehow sort the struct contents by >score, then output? Am I on the right track?
I would create a blank query and write the results from both of your queries to it. Then do a query-of-query with ORDER BY score. That should do it...Just from a quick glance anyway. Andrew Golden ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
