I second that. I have just done something similar although I found that when lots of results were returned by the verity search, something like this far out performed using an 'IN (keyList)' statement (even when the second query returned a huge number of results):
<cfsearch collection="theCollection" criteria="#search#" type="simple" name= "qVerityResults"> <cfquery name="qDBFilterResults" datasource="#theDatasource#"> *SELECT* * *FROM* tableX *WHERE* filters = #theFilters# <!--- yes, cfqueryparam - could be many filters here ---> </cfquery> <cfquery name="qFinalResultSet" dbtype="query" maxrows="#maxRows#"> *SELECT* qVerityResults.*, qDBFilterResults.* *FROM* qVerityResults, qDBFilterResults *WHERE* qVerityResults.*key* = qDBFilterResults.tableXId </cfquery> HTH Dominic On 02/04/2008, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > I use Verity often (including in an education-oriented document management > project that I'm working on), but have avoided categories...probably > because > of the lack of good documentation on their use. > > What I do is index documents with Verity, and have the [key] be the PK in > a > documents table in my database. I will then create any other tables that > I > need to further describe or categorize the data and use that to "refine" > my > verity search by excluding records as needed with an in/not in statement > in > my SQL. That's a very, very boiled down description of the approach I > take, > there does tend to be a lot more going on... > > Pete > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
