Thanks for all your suggestions.
I will look into the Verity links - thanks Joseph - but I may end up taking
Dick's suggestion and put the content into the db. It is created and edited
by the client in a custom-written Windows program, but now that I think
about it there's no reason why I can't read in the file when the program
uploads it and store the text in the db instead of just the filename. So
simple and it was right in front of my nose the whole time!
K.
On Wed, 03 Jan 2001 08:49:51 -0800, "Joseph Thompson" <[EMAIL PROTECTED]>
wrote:
>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.
______________________________________________________
Kay Smoljak - HTML/ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!
Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
