hi Dominic, for some reason your approach with filtering verity results with a qoq gives me an error:
Query Of Queries syntax error. Encountered "vSearch key. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, my qoq is: <cfquery name="qoqSearchResults" dbtype="query"> SELECT * FROM vSearch, dbSearch WHERE vSearch.key = dbSearch.image_id </cfquery> if i switch the columns in the WHERE clause around (WHERE dbSearch.image_id = vSearch.key), i get error: Query Of Queries syntax error. Encountered "KEY. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, Unrecognized character in operand, the qoq syntax is fine, as it works fine with any other qoq... is it due to one query being Verity resultset? any ideas? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Dominic Watson wrote: > 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:302804 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
