OK. So you use Verity to search the docs for the IDs (only) of the relevant documents (with BLOCKFACTOR=100). You then use that list of IDs to select Summaries from the database.
best, paul At 08:18 AM 1/16/03 +0000, you wrote: >Yes I would like veritys search to search through the document and those >fields in the table for more accurate reults and most importantly for the >point below... > >Because in the search results page I want to use the doc summary from the >database to display the actual summary of the document and the doctitle >field from the database to display the title. > >So for example a results returned could be > >Title : Using Ms Word >Summary : This guide is an introduction to this word processing >program....... >Relavance : 84 % > >If I just used verity to search just the document my results will be >something like ... > >Title : �� >Summary: First so many characters of the document >Relavance : 84% > >So by using these two fields from the table the descriptions would be much >more user friendly > > >----- Original Message ----- >From: "paul smith" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, January 15, 2003 4:18 PM >Subject: Re: Can Coldfusion & Verity be this clever ??? > > > > Why would you want to use Verity to search the docs AND the doc summary in > > a DB? (2 queries) > > > > Wouldn't Verity's search of the docs give you all relevant search results? > > (1 query). > > > > best, paul > > > > At 03:47 PM 1/15/03 +0000, you wrote: > > >Hi > > > > > >I am trying to complete the below with verity and would like some advice >on > > >the best way to go about this or can it even be achieved?? > > > > > >I have a database table called 'itdocs'. In this table there are the > > >following fields > > > > > >Docid - which is the primary key > > >DocTitle - title of the document > > >DocSummary - brief summary of the document > > >DocPath - The Actual document name on the web server. > > > > > >What I would like verity to achieve is to search through the actual >document > > >(word, pdf doc) on the server along with the doctitle and docsummary from > > >the itdocs table. > > > > > >Then in the search results page use the Doctitle to display the title and > > >Docsummary for the description from the itdocs table. And to link to the > > >document use the follwoing example /netscape/usr/documents/#docpath# > > > > > >Can this be achieved and how ?? > > > > > >I know that verity can provide the title and summary from the actual doc > > >itself, however this will give a more user friendly search result. > > > > > >Thanks > > > > > >Ian > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
