I'm currently working on a ASP.Net / C# / SQL 2000 project that involves the
entering of keywords, that a web user enters, and then searching MSWord
documents for those words. This information will then be used to perform
weighted searches on the keywords and text of multiple MSWord documents. How
might this best be accomplished? Should I perform Full Text Searches on the
Word files or store the data in a database (by coping and pasting the
document into a Web app page)? If I store it in a database, how would I
store more than 255 characters and then be able to do searches on specific
words? Thanks in advance for your reply!
--
DQdontquit
8  1638 
why cant you use index server
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
news:0C**********************************@microsof t.com... I'm currently working on a ASP.Net / C# / SQL 2000 project that involves
the
entering of keywords, that a web user enters, and then searching MSWord
documents for those words. This information will then be used to perform
weighted searches on the keywords and text of multiple MSWord documents.
How
might this best be accomplished? Should I perform Full Text Searches on
the
Word files or store the data in a database (by coping and pasting the
document into a Web app page)? If I store it in a database, how would I
store more than 255 characters and then be able to do searches on specific
words? Thanks in advance for your reply!
--
DQdontquit
Do you mean Full Text indexing and Full text searches? Do you think this is
the best way to go? Thanks for your reply!
--
DQdontquit
"John Timney ( MVP )" wrote: why cant you use index server
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
news:0C**********************************@microsof t.com... I'm currently working on a ASP.Net / C# / SQL 2000 project that involves
the
entering of keywords, that a web user enters, and then searching MSWord
documents for those words. This information will then be used to perform
weighted searches on the keywords and text of multiple MSWord documents.
How
might this best be accomplished? Should I perform Full Text Searches on
the
Word files or store the data in a database (by coping and pasting the
document into a Web app page)? If I store it in a database, how would I
store more than 255 characters and then be able to do searches on specific
words? Thanks in advance for your reply!
--
DQdontquit
Take a look at it and see what it can give you. Its gonna save you a lot of
work over erinventing the wheel, and its programmable from asp.net
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
news:F1**********************************@microsof t.com... Do you mean Full Text indexing and Full text searches? Do you think this
is
the best way to go? Thanks for your reply!
--
DQdontquit
"John Timney ( MVP )" wrote:
why cant you use index server
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
news:0C**********************************@microsof t.com... > I'm currently working on a ASP.Net / C# / SQL 2000 project that
> involves
> the
> entering of keywords, that a web user enters, and then searching MSWord
> documents for those words. This information will then be used to
> perform
> weighted searches on the keywords and text of multiple MSWord
> documents.
> How
> might this best be accomplished? Should I perform Full Text Searches
> on
> the
> Word files or store the data in a database (by coping and pasting the
> document into a Web app page)? If I store it in a database, how would
> I
> store more than 255 characters and then be able to do searches on
> specific
> words? Thanks in advance for your reply!
> --
> DQdontquit
>
>
Thanks John, I'll investigate Full Text indexing and searches and let
everyone know how it works out. I'm not sure what you meant by "it's
programmable from asp.net. Could you be more specific? Thanks.
--
DQdontquit
"John Timney ( MVP )" wrote: Take a look at it and see what it can give you. Its gonna save you a lot of
work over erinventing the wheel, and its programmable from asp.net
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
news:F1**********************************@microsof t.com... Do you mean Full Text indexing and Full text searches? Do you think this
is
the best way to go? Thanks for your reply!
--
DQdontquit
"John Timney ( MVP )" wrote:
why cant you use index server
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
news:0C**********************************@microsof t.com...
> I'm currently working on a ASP.Net / C# / SQL 2000 project that
> involves
> the
> entering of keywords, that a web user enters, and then searching MSWord
> documents for those words. This information will then be used to
> perform
> weighted searches on the keywords and text of multiple MSWord
> documents.
> How
> might this best be accomplished? Should I perform Full Text Searches
> on
> the
> Word files or store the data in a database (by coping and pasting the
> document into a Web app page)? If I store it in a database, how would
> I
> store more than 255 characters and then be able to do searches on
> specific
> words? Thanks in advance for your reply!
> --
> DQdontquit
>
>
The search results (catalogue queries) can be intercepted and searches
triggered so you can manipulate whats presented or searched for. Worth a
look at given it comes for free on windows servers (if they are your servers
that is).
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
news:D7**********************************@microsof t.com... Thanks John, I'll investigate Full Text indexing and searches and let
everyone know how it works out. I'm not sure what you meant by "it's
programmable from asp.net. Could you be more specific? Thanks.
--
DQdontquit
"John Timney ( MVP )" wrote:
Take a look at it and see what it can give you. Its gonna save you a lot
of
work over erinventing the wheel, and its programmable from asp.net
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
news:F1**********************************@microsof t.com... > Do you mean Full Text indexing and Full text searches? Do you think
> this
> is
> the best way to go? Thanks for your reply!
> --
> DQdontquit
>
>
> "John Timney ( MVP )" wrote:
>
>> why cant you use index server
>>
>> --
>> Regards
>>
>> John Timney
>> ASP.NET MVP
>> Microsoft Regional Director
>>
>> "DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
>> news:0C**********************************@microsof t.com...
>> > I'm currently working on a ASP.Net / C# / SQL 2000 project that
>> > involves
>> > the
>> > entering of keywords, that a web user enters, and then searching
>> > MSWord
>> > documents for those words. This information will then be used to
>> > perform
>> > weighted searches on the keywords and text of multiple MSWord
>> > documents.
>> > How
>> > might this best be accomplished? Should I perform Full Text
>> > Searches
>> > on
>> > the
>> > Word files or store the data in a database (by coping and pasting
>> > the
>> > document into a Web app page)? If I store it in a database, how
>> > would
>> > I
>> > store more than 255 characters and then be able to do searches on
>> > specific
>> > words? Thanks in advance for your reply!
>> > --
>> > DQdontquit
>> >
>> >
>>
>>
>>
DQ dont quit wrote: I'm currently working on a ASP.Net / C# / SQL 2000 project that involves the
entering of keywords, that a web user enters, and then searching MSWord
documents for those words.
Good project.
This information will then be used to perform
weighted searches on the keywords and text of multiple MSWord documents. How
might this best be accomplished? Should I perform Full Text Searches on the
Word files or store the data in a database (by coping and pasting the
document into a Web app page)?
What would be cool is to copy each word, word by word, into a database,
assigning it an integer as to it's place in the document and some other
information that would be useful in searching ( page number, paragraph
number ) and so on.
So, you would create a Text-Search based object model that would be
based on the atomic unit in the database, which consists of all the
words (not many words bigger than 255 that I know of!) and a clustered
index of the place in the document where the word is.
Then you would make a table of noise words, a table of similar words (
singular mapped to plural).
Ok, so then, you would do a fast search by finding all the words, then
grabbing the place, and offering the list to the user. Then, you would
make an interface to move the user to the place inside the document.
If I store it in a database, how would I store more than 255 characters and then be able to do searches on specific
words? Thanks in advance for your reply!
Full-Text Searches are awesome. I created a ASP.NET page that would stream
the MSWORD document (upload) into a MSSQL database table. After installing
the Full-Text component on the Windows Sever, and using the following stored
procedures:
1. sp_fulltext_database
2. sp_fulltext_catalog
3. sp_fulltext_table
4. sp_fulltext_column
5. sp_fulltext_table
6. sp_fulltext_catalog
to set up the catalog on the MSSQL Server (I could not use the Enterprise
Manager "front-end" to because my PC is remote), I was able to perform
searches on the binary data (word doc was stored as binary).
However, I have no clue as to how to allow the user to open the word
document so that they could modify the text and save it again to the
database. John, could you point me in the right direction? Also how do I
"rate" you? Thanks again for your reply!!!
--
DQdontquit
"John Timney ( MVP )" wrote: The search results (catalogue queries) can be intercepted and searches
triggered so you can manipulate whats presented or searched for. Worth a
look at given it comes for free on windows servers (if they are your servers
that is).
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
news:D7**********************************@microsof t.com... Thanks John, I'll investigate Full Text indexing and searches and let
everyone know how it works out. I'm not sure what you meant by "it's
programmable from asp.net. Could you be more specific? Thanks.
--
DQdontquit
"John Timney ( MVP )" wrote:
Take a look at it and see what it can give you. Its gonna save you a lot
of
work over erinventing the wheel, and its programmable from asp.net
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
news:F1**********************************@microsof t.com...
> Do you mean Full Text indexing and Full text searches? Do you think
> this
> is
> the best way to go? Thanks for your reply!
> --
> DQdontquit
>
>
> "John Timney ( MVP )" wrote:
>
>> why cant you use index server
>>
>> --
>> Regards
>>
>> John Timney
>> ASP.NET MVP
>> Microsoft Regional Director
>>
>> "DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
>> news:0C**********************************@microsof t.com...
>> > I'm currently working on a ASP.Net / C# / SQL 2000 project that
>> > involves
>> > the
>> > entering of keywords, that a web user enters, and then searching
>> > MSWord
>> > documents for those words. This information will then be used to
>> > perform
>> > weighted searches on the keywords and text of multiple MSWord
>> > documents.
>> > How
>> > might this best be accomplished? Should I perform Full Text
>> > Searches
>> > on
>> > the
>> > Word files or store the data in a database (by coping and pasting
>> > the
>> > document into a Web app page)? If I store it in a database, how
>> > would
>> > I
>> > store more than 255 characters and then be able to do searches on
>> > specific
>> > words? Thanks in advance for your reply!
>> > --
>> > DQdontquit
>> >
>> >
>>
>>
>>
You've done most of the work already by working out how to instert the
object into the DB. You need to work out how to get binary objects out
again, and they then need to save them locally to work on them, they then
have to be uploaded again and have them reinserted. Its the only way I'm
afraid as they cant work on them on the server so they have to extract them,
do their work and then reinsert them.
Good example here: http://www.developer.com/net/asp/article.php/3097661
Regards
John Timney
Microsoft MVP
"DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
news:74**********************************@microsof t.com... Full-Text Searches are awesome. I created a ASP.NET page that would stream
the MSWORD document (upload) into a MSSQL database table. After installing
the Full-Text component on the Windows Sever, and using the following
stored
procedures:
1. sp_fulltext_database
2. sp_fulltext_catalog
3. sp_fulltext_table
4. sp_fulltext_column
5. sp_fulltext_table
6. sp_fulltext_catalog
to set up the catalog on the MSSQL Server (I could not use the Enterprise
Manager "front-end" to because my PC is remote), I was able to perform
searches on the binary data (word doc was stored as binary).
However, I have no clue as to how to allow the user to open the word
document so that they could modify the text and save it again to the
database. John, could you point me in the right direction? Also how do I
"rate" you? Thanks again for your reply!!!
--
DQdontquit
"John Timney ( MVP )" wrote:
The search results (catalogue queries) can be intercepted and searches
triggered so you can manipulate whats presented or searched for. Worth a
look at given it comes for free on windows servers (if they are your
servers
that is).
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
news:D7**********************************@microsof t.com... > Thanks John, I'll investigate Full Text indexing and searches and let
> everyone know how it works out. I'm not sure what you meant by "it's
> programmable from asp.net. Could you be more specific? Thanks.
> --
> DQdontquit
>
>
> "John Timney ( MVP )" wrote:
>
>> Take a look at it and see what it can give you. Its gonna save you a
>> lot
>> of
>> work over erinventing the wheel, and its programmable from asp.net
>>
>> --
>> Regards
>>
>> John Timney
>> ASP.NET MVP
>> Microsoft Regional Director
>>
>> "DQ dont quit" <DQ********@discussions.microsoft.com> wrote in message
>> news:F1**********************************@microsof t.com...
>> > Do you mean Full Text indexing and Full text searches? Do you think
>> > this
>> > is
>> > the best way to go? Thanks for your reply!
>> > --
>> > DQdontquit
>> >
>> >
>> > "John Timney ( MVP )" wrote:
>> >
>> >> why cant you use index server
>> >>
>> >> --
>> >> Regards
>> >>
>> >> John Timney
>> >> ASP.NET MVP
>> >> Microsoft Regional Director
>> >>
>> >> "DQ dont quit" <DQ********@discussions.microsoft.com> wrote in
>> >> message
>> >> news:0C**********************************@microsof t.com...
>> >> > I'm currently working on a ASP.Net / C# / SQL 2000 project that
>> >> > involves
>> >> > the
>> >> > entering of keywords, that a web user enters, and then searching
>> >> > MSWord
>> >> > documents for those words. This information will then be used to
>> >> > perform
>> >> > weighted searches on the keywords and text of multiple MSWord
>> >> > documents.
>> >> > How
>> >> > might this best be accomplished? Should I perform Full Text
>> >> > Searches
>> >> > on
>> >> > the
>> >> > Word files or store the data in a database (by coping and pasting
>> >> > the
>> >> > document into a Web app page)? If I store it in a database, how
>> >> > would
>> >> > I
>> >> > store more than 255 characters and then be able to do searches on
>> >> > specific
>> >> > words? Thanks in advance for your reply!
>> >> > --
>> >> > DQdontquit
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Alastair |
last post by:
Hello guys,
I've been building a search facility for an intranet site I'm part of
developing and we've been building a search engine using Index Server.
It mostly works, however there have been...
|
by: ziliath |
last post by:
I recently tried out the Google "top coder" contest, as a C++
coder. I noticed immediately that they expected me to know STL.
To which I say, what the fuck?!
I may be missing something, but at...
|
by: joshsackett |
last post by:
I am starting an encryption project for my database and I'm performing
some tests on decryption speed. A lot of my application queries use a
LIKE parameter in the WHERE clause. To keep from...
|
by: junky_fellow |
last post by:
Each time i submit some pattern to "google", it shows search
took 0.XX seconds for exploring millions of web pages.
When i look for efficient ways of searching a string, they always
say compare...
|
by: news.microsoft.com |
last post by:
We need to take a large amount of data, load it into memory, and then search
on it. A hashtable would work if you could perform operations similar to
sql select .. where like ... clauses. Any...
|
by: Derrick |
last post by:
Is there a C# "Like" statement for comparing two strings?
if(stringA Like "%diabe%mel%)
do stuff...
Thanks in advance!
Derrick
|
by: Omar |
last post by:
I've been learning some programming during my little sabbatical (mostly
python), and I thought it'd be cool to see if other people are
interested in programming for music theory. So I started a...
|
by: Drum2001 |
last post by:
Hello All!
I am using the following code during an On Click event for a button.
It works properly to create a query for a report:
Private Sub Command14_Click()
If IsNull(Me.Text30) Then
' No...
|
by: samjnaa |
last post by:
Please check for sanity and approve for posting at python-dev.
In Visual Basic there is the keyword "with" which allows an object-
name to be declared as governing the following statements. For...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
