Dreamweaver - Access - ASP VBScript Database Search Tutorial

Dreamweaver Ultradev, Access 2000, ASP, VBScript, Web site Database Search Tutorial, OLE DB database connection example, Recordset, Search Results, ASP Database Search, VBSCript Database Search Tutorial, multiple paramater web site database search tutorial, multi parameter search, coding, example, tutorials, ASP VBScript Web development

2.0

Specifications for our Search Pages.

The user can enter search words separated by spaces, commas, colons, semicolons, dashes, slashes, hyphens or underscores and the search will still interpret the text as separate words.

The user can specify how they want the search to interpret the entered text. e.g. search for ALL WORDS, ANY WORDS or EXACT PHRASE.

The search can look for matches to the entered text within multiple table columns and separate tables of the database.

The user can specify additional search parameters. In our example Album database the user may search for all formats and music genres or specify particular formats and genres to search. This tutorial will demonstrate how you can add as many additional parameters as you wish in order to allow the user to refine their search.

The user can specify how the search results are sorted and in which order they are to be displayed.

The user can use as many or as few of the search parameters as they wish. e.g. if the user doesn't enter any text and leaves all the following parameters at there default settings then the search will find and display everything. No combination of search parameters will cause the search to fail or give nasty database driver error messages.