Yes, Verity would work for you. Verity provides a mechanism to populate the
Verity collection from a query.
In your case, you may need to run one query to get the file name, category
etc. from your dbase, and then combine the results with a CFFILE read
operation and use the "QueryAddRow" function to add the contents of your
HTML files to the query...
There is a "Verity manager" script here at cfhub you can try, it will use
the first <header> (HI,H2 etc) to name your documents and allow you to skip
the step of dynamically building your query.
More on Dynamic queries:
http://cfhub.com/advanced/cfquery/index.cfm
More on Verity:
http://cfhub.com/advanced/verity/index.cfm
The Verity Manager script:
http://cfhub.com/tutorials/verity/
If you have any questions about any of these links, let me know (off list)
========================
Subject: Is this a job for Verity?
> Hi all,
>
> I have an application hosted on CFAS 4.0.1/MS SQL Server 7 which requires
a
> search feature for news articles. The article text for each item is stored
> in an external html file. The title, category, date and filename for each
> article is stored in the db. I am kinda stumped as to how I can elegantly
> search the full text of the articles. Could this be a job for Verity? I
have
> not used it before. And if it is, how can I associate the correct db entry
> with the text in the external file in my search results?
>
> Thanks for any pointers,
> K.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
