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

4.0

The Database

The tutorial will use a small database containing a collection of music albums. The Database consists of the following 5 tables:

Albums Table

AlbumID	GenreID	ArtistName	AlbumTitle
1	10	Beck	Mellow Gold
2	10	Beck	Odelay
3	10	Beck	Mutations
4	10	Beck	Midnite Vultures
5	2	AIR	Moon Safari
6	7	Pepe Deluxe	Super Sound
7	7	The Avalanches	Since I Left You
8	2	Stereolab	Emperor Tomato Ketchup
9	1	Foo Fighters	Foo Fighters
10	1	Foo Fighters	There Is Nothing Left To Lose
11	4	The Breeders	Last Splash
12	1	Eels	Beautiful Freak
13	1	Eels	Daisies Of The Galaxy
14	7	Asian Dub Foundation	Community Music
15	2	Joy Division	Permanent
16	2	Leonard Cohen	Greatest Hits
17	1	Pixies	Doolittle
18	1	Pixies	Bossanova
19	1	Pixies	Trompe Le Monde
20	7	Propellerheads	DECKSANDRUMSANDROCKANDROLL
21	6	Prokofiev	Romio And Juliet
22	6	Vivaldi	The Four Seasons (Le Quattro Stagioni)
23	2	Pizzicato Five	Playboy & Playgirl
24	6	Sergei Rachmaninov	Piano Concertos 1 - 4
25	6	Beethoven	The Symphonies - 6 CD Set
(Autonumber)

TrackListings Table (Top 15 rows)

AlbumID	TrackNumber	Track
1	1	Loser
1	2	Pay No Mind
1	3	F---in With My Head
1	4	Whiskeyclone, Hotel City 1997
1	5	Soul Suckin Jerk
1	6	Truckdrivin neighbors Downstairs (Yellow Sweat)
1	7	Sweet Sunshine
1	8	Beercan
1	9	Steal My Body Home
1	10	Nitemare Hippy Girl
1	11	Mutherf--er
1	12	Blackhole
2	1	Devils Haircut
2	2	Hotwax
2	3	Lord Only Knows
2	4	The New Polution

Formats Table

FormatID	Format
1	CD
2	Vinyl LP
3	Casette
4	Minidisc
(Autonumber)

Genres Table

GenreID	Genre
1	Rock
2	Pop
3	Jazz
4	Indie
5	Regae
6	Classical
7	Dance
8	Folk
9	Country
10	Other
11	Punk
(Autonumber)

AlbumFormats Table (Top 10 rows)

AlbumID	FormatID
1	1
1	2
1	3
1	4
2	1
2	2
2	3
2	4
3	1
3	3

The Database Relationships

Ref	Table 1	Field1	Table2	Field2	Relationship
1	Genres	GenreID	Albums	GenreID	One to Many
2	Albums	AlbumID	TrackListings	AlbumID	One to Many

3	Albums	AlbumID	AbumFormats	AlbumID	One to Many
4	Formats	FormatID	AbumFormats	FormatID	One to Many

5	Albums	AlbumID	Formats	FormatID	Many to Many

Note The Many to Many Relationship 5 is achieved with an intermediate table AlbumFormats utilising the two One to Many relationhips 3 & 4.