Hi all, I have a verity search result (say VerityResults) that has the key as the primary id of a database table. I know that I can use this primary id as a parameter for retreiving results from the database like so:
<cfquery datasource ="thisDSN" name="thisQuery"> SELECT * FROM thisTable WHERE PrimaryID IN (#ValueList(VerityResults.Key),",")#) </cfquery> However I would like to order the results in thisQuery as the same as thescore of the VerityResults. Is there some elegant way to do this without resorting to a queryMerge UDF or somthing like that? TIA, George ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205230 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
