|
 |
asp_web_howto thread: Display sentence
Message #1 by "dirk beentjes" <oerpie@h...> on Wed, 25 Apr 2001 12:40:45 +0200
|
|
Hi there
Lets say I have found a word in a sentence. The sentence is part of a record
in a database. The whole record contains more sentences.
What I would like to do is display the sentence where the word is in.
For example:
(record)
This is a test. And this is another one. The word is ASP. And so on. And so
on.
(word)
ASP
(result)
The word is ASP.
Ho can I achieve this?
Thanks,
Dirk
(The Netherlands, that's why my english is so bad)
Message #2 by "H. Carter Harris" <carter@t...> on Wed, 25 Apr 2001 08:40:19 -0500
|
|
I apologize if this was explained in a previous post, but what db engine are
you using?
With SQL Server you can do a full text search and then extract before and
after the occurance of the search string with another SQL statement.
-----Original Message-----
From: dirk beentjes [mailto:oerpie@h...]
Sent: Wednesday, April 25, 2001 5:41 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Display sentence
Hi there
Lets say I have found a word in a sentence. The sentence is part of a record
in a database. The whole record contains more sentences.
What I would like to do is display the sentence where the word is in.
For example:
(record)
This is a test. And this is another one. The word is ASP. And so on. And so
on.
(word)
ASP
(result)
The word is ASP.
Ho can I achieve this?
Thanks,
Dirk
(The Netherlands, that's why my english is so bad)
Message #3 by "TomMallard" <mallard@s...> on Wed, 25 Apr 2001 11:09:57 -0700
|
|
FWIW, I've been working on a parser that uses files as input, strips tags,
separates the sentences in each and inserts those into tables for searching.
Right now the conversion takes less than a second on a p600/256mb/sql7 for a
40k file (same thing takes five seconds with a p300/130mb/access2000).
Search results are quick and relevent, easy to copy/paste into other doc's.
Still playing with it...
tom
----- Original Message -----
From: "H. Carter Harris" <carter@t...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Wednesday, April 25, 2001 6:40 AM
Subject: [asp_web_howto] RE: Display sentence
> I apologize if this was explained in a previous post, but what db engine
are
> you using?
>
> With SQL Server you can do a full text search and then extract before and
> after the occurance of the search string with another SQL statement.
>
>
> -----Original Message-----
> From: dirk beentjes [mailto:oerpie@h...]
> Sent: Wednesday, April 25, 2001 5:41 AM
> To: ASP Web HowTo
> Subject: [asp_web_howto] Display sentence
>
>
> Hi there
>
> Lets say I have found a word in a sentence. The sentence is part of a
record
> in a database. The whole record contains more sentences.
> What I would like to do is display the sentence where the word is in.
>
> For example:
>
> (record)
> This is a test. And this is another one. The word is ASP. And so on. And
so
> on.
>
> (word)
> ASP
>
> (result)
> The word is ASP.
>
> Ho can I achieve this?
> Thanks,
>
> Dirk
> (The Netherlands, that's why my english is so bad)
Message #4 by "dirk beentjes" <oerpie@h...> on Thu, 26 Apr 2001 09:23:54 +0200
|
|
I'm using a Access Database.
The searching in the database is working really good. But I want to display
the whole sentence the searched-word was in.
Dirk
>From: "H. Carter Harris" <carter@t...>
>Reply-To: "ASP Web HowTo" <asp_web_howto@p...>
>To: "ASP Web HowTo" <asp_web_howto@p...>
>Subject: [asp_web_howto] RE: Display sentence
>Date: Wed, 25 Apr 2001 08:40:19 -0500
>
>I apologize if this was explained in a previous post, but what db engine
>are
>you using?
>
>With SQL Server you can do a full text search and then extract before and
>after the occurance of the search string with another SQL statement.
>
>
>-----Original Message-----
>From: dirk beentjes [mailto:oerpie@h...]
>Sent: Wednesday, April 25, 2001 5:41 AM
>To: ASP Web HowTo
>Subject: [asp_web_howto] Display sentence
>
>
>Hi there
>
>Lets say I have found a word in a sentence. The sentence is part of a
>record
>in a database. The whole record contains more sentences.
>What I would like to do is display the sentence where the word is in.
>
>For example:
>
>(record)
>This is a test. And this is another one. The word is ASP. And so on. And so
>on.
>
>(word)
>ASP
>
>(result)
>The word is ASP.
>
>Ho can I achieve this?
>Thanks,
>
>Dirk
>(The Netherlands, that's why my english is so bad)
>
>
|
|
|
View Cart
