We have a web site that's basically made of technical articles.

We use an Access database where we store the title, date and name of the 

files (all files in txt format). We choose this way to not make the 

database too big by using memo fields to store the full articles.

Through our website visitors can access this articles just clicking on the 

links, dinamically generated. (Our site is all ASP). The asp code search 

the database for the title of the article and then inserts the text file 

into the generated page.

Now we need to create a search mechanism for the articles.

The problem is how to do this, the text files are not indexed to the 

database.

And the database do not contains any keywords linking the record to the 

text, just the title.

Any sugestions on how we could achieve this.

Or we must redo our work to include the text on a memo field on the 

database. We had problems with memo fields previously and would like to 

avoid this alternative.



Thanks for any help.



If anyone is insterest in see what i'm talking about please visit 

www.milkpoint.com.br - (as we're located in Brazil the site is in 

portuguese)

i had a similar problem, i am an asp guy but i consider this thing more

easily done by a spider.  rather than write one myself i'm evaluating these.



lvrfy (Shell Script)

http://www.cs.dartmouth.edu/~crow/lvrfy.html



check out Cyber Spyder at 

http://www.cyberspyder.com

Use the Index(ing) Serv(er|ice). This gets acound the Access issue and

covers your apparent needs.



kt



On Wed, 26 Apr 2000, Luis Carlos Marinho wrote:



> We have a web site that's basically made of technical articles.

> We use an Access database where we store the title, date and name of the 

> files (all files in txt format). We choose this way to not make the 

> database too big by using memo fields to store the full articles.

> Through our website visitors can access this articles just clicking on the 

> links, dinamically generated. (Our site is all ASP). The asp code search 

> the database for the title of the article and then inserts the text file 

> into the generated page.

> Now we need to create a search mechanism for the articles.

> The problem is how to do this, the text files are not indexed to the 

> database.

> And the database do not contains any keywords linking the record to the 

> text, just the title.

> Any sugestions on how we could achieve this.

> Or we must redo our work to include the text on a memo field on the 

> database. We had problems with memo fields previously and would like to 

> avoid this alternative.

> 

> Thanks for any help.

> 

> If anyone is insterest in see what i'm talking about please visit 

> www.milkpoint.com.br - (as we're located in Brazil the site is in 

> portuguese)

> 

> ---

> You are currently subscribed to asp_databases 


>