You can try using query of query. This can work ok in many cases. Use
QueryValueList (or something like that) to extract the primary key
values from the verity results, and then use them to create a db query
that retrieves those rows. Last step is to combine them with q-of-q.
Mark
-----Original Message-----
From: George Abraham [mailto:[EMAIL PROTECTED]
Sent: Monday, May 02, 2005 2:01 PM
To: CF-Talk
Subject: Re: Combining verity results with database query
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
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205290
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
