This article, by Jerry Wood, shows a nifty little script, which, with just one ASP page, allows you to dynamically search a column in a table using a string comparison. This one script can be used over and over due to its dynamic nature! Hopefully this script will save you valuable time by cutting down on the often repetitive task of creating small, searching scripts!

So, you may be wondering how to use this script! Well, trust me, it isn't difficult. Let's say

There are many ways to implement a search on your site - I asked you to pick from three of them in the search survey I did recently.
The method that most people picked entailed me reading every page on the site and hand-picking keywords. These keywords were entered into a new table, ArticlePages. You can get the source code for the entire site, including the database

As a web site grows, finding content on the site becomes increasingly difficult. To combat the difficulty of finding relevant information on a large site, many developers turn to writing a search engine for their site. This article discusses how to implement such a system using Active Server Pages and SQL Server.

There are two "types" of search engines. Both take a search string from the user to begin, but what, exactly, they search differs. A completely dynamic search engine for a completely dynamic web site will hit a database table which ties an article URL to the articles description. The database can then compare the user's search request to the descriptions of the available articles and return the relevant URLs.

Another approach is to do an actual text search through each of the files. For example, say that the user searched for "Microsoft." Your search engine would then look through all of your HTML files and return the URLs of those which had the word "Microsoft" somewhere in the document. Such a system is used for this web site's search engine. In my opinion, it is much easier to write such a system described in Perl (which this system is written in), than in Active Server Pages; however, it is quite possible to write a text-finding search system in ASP.

In this article I plan to implement the former search engine, the dynamic search engine. For this example I will make a table called ArticleURL, which will have the following definition

I was thinking one day, wouldn't it be nice if any given web site knew what I was specifically looking for when I arrived? I think it would be very helpful.

Then I started thinking about it a little more, and decided it was time to do something about it. At first, I sat down and wrote a letter to my congressman, but then decided he probably would have no idea what I was talking about, so I would have to resort to getting down and dirty with the code myself.

My Father-in-law runs a small e-commerce site that I designed. Which was a perfect platform to test out my new idea once completed. I sat down, wrote the code, uploaded it to the server and tested it out. Much to my chagrin, it worked perfectly, and proved to be a very good idea.

Most web trend articles say that, if a user does not find what they are looking for in 3 clicks or less, the majority of them will move on to greener pastures. This code will bring them to exactly where they want to go in 1 click

We will begin with creating a set of ASP pages to index the site content and then insert into the database. Here you will learn how easy it practically is to deal with databases in ASP. All statements of SQL select, insert, update and delete will come into play.