doing a search

[middletree]

Intranet tech support system using ASP/VBScript running on W2000 Server,
IIS, and using SQL Server 2000. I need to add a search engine. The problem
with using a regular SQL query is that if you put a phrase, say "red car" in
the text box, to hit submit, my SQL qurey would only look for that phrase,
and would leave out other items where the words red and car appeared
separately. I guess what I am saying is that I would like something like
Google or other search engines, which would find results which seem to fit
the criteria typed into the box, and rank them and highlight key words.

My research so far has shown me that SQL Server has something called
Full-Text searching, and I have tried to read up on that in BOL, but not
really seeing how I can apply it. I wonder if there's already some tutorials
or sample code out there. I have done some looking on the Web, but still
haven't found much. Does anyone here know where I can look? Having some
sample code would be best.

[Bob Barrows [MVP]]

Re: doing a search

middletree wrote:[color=blue]
> Intranet tech support system using ASP/VBScript running on W2000
> Server, IIS, and using SQL Server 2000. I need to add a search
> engine. The problem with using a regular SQL query is that if you put
> a phrase, say "red car" in the text box, to hit submit, my SQL qurey
> would only look for that phrase, and would leave out other items
> where the words red and car appeared separately. I guess what I am
> saying is that I would like something like Google or other search
> engines, which would find results which seem to fit the criteria
> typed into the box, and rank them and highlight key words.
>
> My research so far has shown me that SQL Server has something called
> Full-Text searching, and I have tried to read up on that in BOL, but
> not really seeing how I can apply it. I wonder if there's already
> some tutorials or sample code out there. I have done some looking on
> the Web, but still haven't found much. Does anyone here know where I
> can look? Having some sample code would be best.[/color]

Unfortunately, I've never done anything with full-text indexing.
There's a newsgroup devoted to fulltext issues:
microsoft.publi c.sqlserver.ful ltext. You may get an answer there.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[middletree]

Re: doing a search

Yes, I've spent the last month looking at posts there. I was just hoping
there might be a tutorial already written somewhere, sample code to get me
started. Oh well.


"Bob Barrows [MVP]" <reb01501@NOyah oo.SPAMcom> wrote in message
news:#JAMQj6NEH A.2468@TK2MSFTN GP11.phx.gbl...[color=blue]
> middletree wrote:[color=green]
> > Intranet tech support system using ASP/VBScript running on W2000
> > Server, IIS, and using SQL Server 2000. I need to add a search
> > engine. The problem with using a regular SQL query is that if you put
> > a phrase, say "red car" in the text box, to hit submit, my SQL qurey
> > would only look for that phrase, and would leave out other items
> > where the words red and car appeared separately. I guess what I am
> > saying is that I would like something like Google or other search
> > engines, which would find results which seem to fit the criteria
> > typed into the box, and rank them and highlight key words.
> >
> > My research so far has shown me that SQL Server has something called
> > Full-Text searching, and I have tried to read up on that in BOL, but
> > not really seeing how I can apply it. I wonder if there's already
> > some tutorials or sample code out there. I have done some looking on
> > the Web, but still haven't found much. Does anyone here know where I
> > can look? Having some sample code would be best.[/color]
>
> Unfortunately, I've never done anything with full-text indexing.
> There's a newsgroup devoted to fulltext issues:
> microsoft.publi c.sqlserver.ful ltext. You may get an answer there.
>
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email account is my spam trap so I
> don't check it very often. If you must reply off-line, then remove the
> "NO SPAM"
>
>[/color]

[TomB]

Re: doing a search

Did you try

http://www.microsoft.com/sql/evaluation/features/fulltext.asp

it has a link to "Building Search Applications for the Web Using Microsoft
SQL Server 2000 Full-Text Search"

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_fulltextsearch.asp

as well as English Query

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/eqbol/eqconcpt_1koj.asp

"middletree " <middletree@HTO mail.com> wrote in message
news:eRZpp$8NEH A.268@TK2MSFTNG P11.phx.gbl...[color=blue]
> Yes, I've spent the last month looking at posts there. I was just hoping
> there might be a tutorial already written somewhere, sample code to get me
> started. Oh well.
>
>
> "Bob Barrows [MVP]" <reb01501@NOyah oo.SPAMcom> wrote in message
> news:#JAMQj6NEH A.2468@TK2MSFTN GP11.phx.gbl...[color=green]
> > middletree wrote:[color=darkred]
> > > Intranet tech support system using ASP/VBScript running on W2000
> > > Server, IIS, and using SQL Server 2000. I need to add a search
> > > engine. The problem with using a regular SQL query is that if you put
> > > a phrase, say "red car" in the text box, to hit submit, my SQL qurey
> > > would only look for that phrase, and would leave out other items
> > > where the words red and car appeared separately. I guess what I am
> > > saying is that I would like something like Google or other search
> > > engines, which would find results which seem to fit the criteria
> > > typed into the box, and rank them and highlight key words.
> > >
> > > My research so far has shown me that SQL Server has something called
> > > Full-Text searching, and I have tried to read up on that in BOL, but
> > > not really seeing how I can apply it. I wonder if there's already
> > > some tutorials or sample code out there. I have done some looking on
> > > the Web, but still haven't found much. Does anyone here know where I
> > > can look? Having some sample code would be best.[/color]
> >
> > Unfortunately, I've never done anything with full-text indexing.
> > There's a newsgroup devoted to fulltext issues:
> > microsoft.publi c.sqlserver.ful ltext. You may get an answer there.
> >
> > Bob Barrows
> > --
> > Microsoft MVP - ASP/ASP.NET
> > Please reply to the newsgroup. This email account is my spam trap so I
> > don't check it very often. If you must reply off-line, then remove the
> > "NO SPAM"
> >
> >[/color]
>
>[/color]

[middletree]

Re: doing a search

This looks good. Thanks. I guess I was doing all my searches on sites like
4guysfromrolla and aspfaq and other 3rd-party sites. I should have done a
better job of going to the original source.


"TomB" <shuckle@hotmai lXXX.com> wrote in message
news:ePb20QCOEH A.2716@tk2msftn gp13.phx.gbl...[color=blue]
> Did you try
> http://www.microsoft.com/sql/evaluat...s/fulltext.asp
> it has a link to "Building Search Applications for the Web Using Microsoft
> SQL Server 2000 Full-Text Search"
>[/color]
http://msdn.microsoft.com/library/de...textsearch.asp[color=blue]
> as well as English Query
>[/color]
http://msdn.microsoft.com/library/de...oncpt_1koj.asp[color=blue]
>
> "middletree " <middletree@HTO mail.com> wrote in message
> news:eRZpp$8NEH A.268@TK2MSFTNG P11.phx.gbl...[color=green]
> > Yes, I've spent the last month looking at posts there. I was just hoping
> > there might be a tutorial already written somewhere, sample code to get[/color][/color]
me[color=blue][color=green]
> > started. Oh well.
> >
> >
> > "Bob Barrows [MVP]" <reb01501@NOyah oo.SPAMcom> wrote in message
> > news:#JAMQj6NEH A.2468@TK2MSFTN GP11.phx.gbl...[color=darkred]
> > > middletree wrote:
> > > > Intranet tech support system using ASP/VBScript running on W2000
> > > > Server, IIS, and using SQL Server 2000. I need to add a search
> > > > engine. The problem with using a regular SQL query is that if you[/color][/color][/color]
put[color=blue][color=green][color=darkred]
> > > > a phrase, say "red car" in the text box, to hit submit, my SQL qurey
> > > > would only look for that phrase, and would leave out other items
> > > > where the words red and car appeared separately. I guess what I am
> > > > saying is that I would like something like Google or other search
> > > > engines, which would find results which seem to fit the criteria
> > > > typed into the box, and rank them and highlight key words.
> > > >
> > > > My research so far has shown me that SQL Server has something called
> > > > Full-Text searching, and I have tried to read up on that in BOL, but
> > > > not really seeing how I can apply it. I wonder if there's already
> > > > some tutorials or sample code out there. I have done some looking on
> > > > the Web, but still haven't found much. Does anyone here know where I
> > > > can look? Having some sample code would be best.
> > >
> > > Unfortunately, I've never done anything with full-text indexing.
> > > There's a newsgroup devoted to fulltext issues:
> > > microsoft.publi c.sqlserver.ful ltext. You may get an answer there.
> > >
> > > Bob Barrows
> > > --
> > > Microsoft MVP - ASP/ASP.NET
> > > Please reply to the newsgroup. This email account is my spam trap so I
> > > don't check it very often. If you must reply off-line, then remove the
> > > "NO SPAM"
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]