I'm currently working on a ASP.Net / C# / SQL 2000 project that involves the
input of keywords and MSWord documents into a web app and storing them in a
SQL database.. This information will then be used to perform weighted
searches on the keywords and text of the MSWord documents. How might this
best be accomplished?
--
DQdontquit

Well I programmed something like that a couple of years ago.
I stored the word documents on a harddrive searched throught them using
indexing service. You can use this service from within Sql Server.
Sql Server had a table with the names of the files to keep history
information.

Kind Regards.

--
Rainier van Slingerlandt
(Freelance trainer/consultant/developer)
www.slingerlandt.com


"DQ dont quit" wrote:

Do you think today it would be best to take advatage of SQL's Full Text File
searches on the Word docs since I can't see how I could store the text for
the doc file in the database if it contains more than 255 characters.
--
DQdontquit


"Rainier [MCT]" wrote:

eYes, if I had to develop a search thrue Wrod documents keeping a reference
in a SQL Server I would do the same thing again.
I wouldn't store the documents in de database evendo it is possible (blobs
of binairy data)

The search engine of the operating system takes the biggest load of your
shoulder developing a search engine. So I would use it.

Kind Regards.

--
Rainier van Slingerlandt
(Freelance trainer/consultant/developer)
www.slingerlandt.com


"DQ dont quit" wrote: