ASP/.NET Web Hosting
* 3 Months FREE *
CLICK HERE!
 CoverYourASP --> Searching articles for hand-picked keywords

Free membership

Join in the fun! Sign in
Member Services

Site navigation
Download the entire site!
Search my articles
Free Magazines
Browse the directory

Send me feedback
Buy my boxer shorts

Recommend this page
Printer-friendly page

Resources I recommend
Link to my site
Advertising slashed!
About your privacy
Legal stuff
Site statistics
64 active users
417 visitors today
409 pages today
(only part of today)
ASP.NET Showcase
ASP.NET Graph and Chart Component with FREE developer version

ASP.NET Shopping Cart and E-commerce Control with FREE trial download

ASP.NET Web Hosting with free month and setup

$15 Domain Name Registration from .DNR.
As seen on these sites
Special thanks go to the sites that support me by publishing my articles.
See more

CoverYourASP
Copyright © 1999-2008 James Shaw.
All rights reserved.

ASP.NET Blog
ASPRSS
ShawThing

Now open source with SourceForge!

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, here.

This table is used for many purposes, not just searching - the data for the breadcrumbs and previous/next page links in the articles are also stored here.

For searching purposes we are interested in just three fields: URL, ShortDescr and Keywords. I'll show you how I created a SSI to display and process the search form, turn the search expression into SQL and display the results.

Part 2: The Search.asp SSI...

Featured sponsor
My favorite resources

Selling products online - read how James does it now



I share my content

Supporting ASPRSS

Do you need a quick and easy way to link to my articles? All the information you need is published with ASPRSS...


See my source code
wherever you see this icon...

You can also download the entire site source code for FREE!