Anybody? On 5/2/05, George Abraham <[EMAIL PROTECTED]> wrote: > 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:205287 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
