making a search engine--sample code requested

[middletree]

I am researching with Google and ASP-specific sites how to make a search
engine for my browser-based tech support application for tracking tickets. I
want to be able to search two varchar fields in my SQL Server database and
return a list of possible matches, just like most search engines.

What I am finding is that there are zillions of samples of code out there,
even when limiting it to Classic ASP. Can anyone recommend some code that
really works well? I could test them all, but I'd like to hear from those
who have actually tested the waters.

 

[William Morris]

This sounds more like a SQL question than an ASP question. You need a form
to get values from the user, then submit that form to an ASP page for
processing, firing off a query to the database to return a set of values.
Pretty standard stuff.

You might have a look at "full text indexes" in SQL Server BOL. Also, the
"LIKE" statement.

 

[middletree]

I know the form stuff, but I was asking about the SQL and how to display it
on the results page. Some search engines, for example, will highglight, or
put in bold, the text you were searching for.

I do, of course, know about LIKE, but that only helps if you want an exact
string. I am trying to find out how, if a user types in the words pink
elephant, it will return a recordset of appropriate records which include
the word pink, the word elephant, but not neccessarily in that order, or not
necessarily both. But if it does have both, then it would place those
results higher, and if it had those two words in order, it would be highest
in the returned set.

Again, I saw some stuff out at 4guysfromrolla.com and other places, but am
still looking, and if anyone already had a handle on a good script for me to
build on, then this post would be a success.