ASP Help needed

I'm trying to make a music CD webpage (eg hmv.com) using ASP. I want it to
follow these guidelines:
All visitors should be able to obtain a list of
1 - all CDs in the database listed by A-Z by arist name
2 - CD's which price is within a range (minimum & maximum) specified by the
user
3 - titles of the tracks on a CD
4 - CD's which include both CD & track titles contains keywords inputted
into a 'search box'
5 - Also an option that allows 'admin' users to login & recieve an exta
option of being able to list CD's in order of interest (no of hits per CD,
so to speak)

Note - The database is in MS Access (no relations have been created)

Can anyone provide me good content-specific links that will help me this
Thank you.

re: ASP Help needed

So basically you want a shopping cart type thing?

There are plenty of examples on www.planet-source-code.com

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)
*** HAWK <nosharemail@INVALID.mail.com.Invalid> wrote in message
news:3fbcb2a3$0$2393$cc9e4d1f@news.dial.pipex.com. ..[color=blue]
> I'm trying to make a music CD webpage (eg hmv.com) using ASP. I want it to
> follow these guidelines:
> All visitors should be able to obtain a list of
> 1 - all CDs in the database listed by A-Z by arist name
> 2 - CD's which price is within a range (minimum & maximum) specified by[/color]
the[color=blue]
> user
> 3 - titles of the tracks on a CD
> 4 - CD's which include both CD & track titles contains keywords inputted
> into a 'search box'
> 5 - Also an option that allows 'admin' users to login & recieve an exta
> option of being able to list CD's in order of interest (no of hits per CD,
> so to speak)
>
> Note - The database is in MS Access (no relations have been created)
>
> Can anyone provide me good content-specific links that will help me this
> Thank you.
>
>[/color]

re: ASP Help needed

Sounds like a perfectly reasonable program spec to me...what exactly do you
need help on?

"*** HAWK" <nosharemail@INVALID.mail.com.Invalid> wrote in message
news:3fbcb2a3$0$2393$cc9e4d1f@news.dial.pipex.com. ..[color=blue]
> I'm trying to make a music CD webpage (eg hmv.com) using ASP. I want it to
> follow these guidelines:
> All visitors should be able to obtain a list of
> 1 - all CDs in the database listed by A-Z by arist name
> 2 - CD's which price is within a range (minimum & maximum) specified by[/color]
the[color=blue]
> user
> 3 - titles of the tracks on a CD
> 4 - CD's which include both CD & track titles contains keywords inputted
> into a 'search box'
> 5 - Also an option that allows 'admin' users to login & recieve an exta
> option of being able to list CD's in order of interest (no of hits per CD,
> so to speak)
>
> Note - The database is in MS Access (no relations have been created)
>
> Can anyone provide me good content-specific links that will help me this
> Thank you.
>
>[/color]

re: ASP Help needed

Ok. My database called 'cdshop.mdb' has 3 tables as follows:
1 - 'tblMusicAlbums'
2 - 'tblMusicTracks'
3 - 'tblPasswords'

Fields in 'tblMusicAlbums' are: "AlbumID" "AlbumTitle" "Artist"
"MusicCategoryID" "Label" "ReleaseDate" "NumberOfTracks"

Fields in 'tblMusicTracks' are:
"TrackID" "AlbumID" "TrackNumber" "TrackTitle"

Fields in 'tblPasswords' are:
"Username" "Password"

I am making an *.asp file that will connect to the database using a DSN-Less
connection at home (although this is for testing purposes at home - I will
need to alter this to a DSN connection once its completed)

The main priorities of the site are as follows:
Using a series of input fields /jump menus / submit buttons the visitor must
be able to do the following:
1 - Obtain a list of ALL CD's in the database listed A-Z by Artist
2 - Obtain a list of CD's by a certain artist listed by release date
3 - Obtain a list of CD's whose price is within a range (minimum & maximum)
as specified by the user.
4 - Obtain a list of titles of the tracks on any selected CD
5 - CD's whose overall CD title or track titles contains a keyword input by
the visitor
6 - Create an login that will enable only 'admin users' to obtain a list of
CD's in order of interest as measured by the number of equiries about each
CD retrieved in requirement 4 (eg no of hits per CD/Album)



The database contains 20+ albums (only small scale for this purpose is
needed). Using SQL to perform the actions as mentioned earlier.



Thanks. let me know if this isn't very clear. remember I am somewhat a
beginner to ASP so please be gentle with me :-)

"William Morris" <NOwmorrisS_P-A.M@seamlyne.com> wrote in message
news:bpiirg$1n2fpj$1@ID-205671.news.uni-berlin.de...
[color=blue]
> Sounds like a perfectly reasonable program spec to me...what exactly do[/color]
you[color=blue]
> need help on?
>
> "*** HAWK" <nosharemail@INVALID.mail.com.Invalid> wrote in message
> news:3fbcb2a3$0$2393$cc9e4d1f@news.dial.pipex.com. ..[color=green]
> > I'm trying to make a music CD webpage (eg hmv.com) using ASP. I want it[/color][/color]
to[color=blue][color=green]
> > follow these guidelines:
> > All visitors should be able to obtain a list of
> > 1 - all CDs in the database listed by A-Z by arist name
> > 2 - CD's which price is within a range (minimum & maximum) specified by[/color]
> the[color=green]
> > user
> > 3 - titles of the tracks on a CD
> > 4 - CD's which include both CD & track titles contains keywords inputted
> > into a 'search box'
> > 5 - Also an option that allows 'admin' users to login & recieve an exta
> > option of being able to list CD's in order of interest (no of hits per[/color][/color]
CD,[color=blue][color=green]
> > so to speak)
> >
> > Note - The database is in MS Access (no relations have been created)
> >
> > Can anyone provide me good content-specific links that will help me this
> > Thank you.
> >
> >[/color]
>
>[/color]

re: ASP Help needed

Ideally, I just need web resources that help me going with setting up the
SQL in relation to the form objects.
I hope what I'm sayin is making sense - tell me if it isn't :-)
"*** HAWK" <nosharemail@INVALID.mail.com.Invalid> wrote in message
news:3fbe1826$0$24060$cc9e4d1f@news.dial.pipex.com ...[color=blue]
> Ok. My database called 'cdshop.mdb' has 3 tables as follows:
> 1 - 'tblMusicAlbums'
> 2 - 'tblMusicTracks'
> 3 - 'tblPasswords'
>
> Fields in 'tblMusicAlbums' are: "AlbumID" "AlbumTitle" "Artist"
> "MusicCategoryID" "Label" "ReleaseDate" "NumberOfTracks"
>
> Fields in 'tblMusicTracks' are:
> "TrackID" "AlbumID" "TrackNumber" "TrackTitle"
>
> Fields in 'tblPasswords' are:
> "Username" "Password"
>
> I am making an *.asp file that will connect to the database using a[/color]
DSN-Less[color=blue]
> connection at home (although this is for testing purposes at home - I will
> need to alter this to a DSN connection once its completed)
>
> The main priorities of the site are as follows:
> Using a series of input fields /jump menus / submit buttons the visitor[/color]
must[color=blue]
> be able to do the following:
> 1 - Obtain a list of ALL CD's in the database listed A-Z by Artist
> 2 - Obtain a list of CD's by a certain artist listed by release date
> 3 - Obtain a list of CD's whose price is within a range (minimum &[/color]
maximum)[color=blue]
> as specified by the user.
> 4 - Obtain a list of titles of the tracks on any selected CD
> 5 - CD's whose overall CD title or track titles contains a keyword input[/color]
by[color=blue]
> the visitor
> 6 - Create an login that will enable only 'admin users' to obtain a list[/color]
of[color=blue]
> CD's in order of interest as measured by the number of equiries about each
> CD retrieved in requirement 4 (eg no of hits per CD/Album)
>
>
>
> The database contains 20+ albums (only small scale for this purpose is
> needed). Using SQL to perform the actions as mentioned earlier.
>
>
>
> Thanks. let me know if this isn't very clear. remember I am somewhat a
> beginner to ASP so please be gentle with me :-)
>
> "William Morris" <NOwmorrisS_P-A.M@seamlyne.com> wrote in message
> news:bpiirg$1n2fpj$1@ID-205671.news.uni-berlin.de...
>[color=green]
> > Sounds like a perfectly reasonable program spec to me...what exactly do[/color]
> you[color=green]
> > need help on?
> >
> > "*** HAWK" <nosharemail@INVALID.mail.com.Invalid> wrote in message
> > news:3fbcb2a3$0$2393$cc9e4d1f@news.dial.pipex.com. ..[color=darkred]
> > > I'm trying to make a music CD webpage (eg hmv.com) using ASP. I want[/color][/color][/color]
it[color=blue]
> to[color=green][color=darkred]
> > > follow these guidelines:
> > > All visitors should be able to obtain a list of
> > > 1 - all CDs in the database listed by A-Z by arist name
> > > 2 - CD's which price is within a range (minimum & maximum) specified[/color][/color][/color]
by[color=blue][color=green]
> > the[color=darkred]
> > > user
> > > 3 - titles of the tracks on a CD
> > > 4 - CD's which include both CD & track titles contains keywords[/color][/color][/color]
inputted[color=blue][color=green][color=darkred]
> > > into a 'search box'
> > > 5 - Also an option that allows 'admin' users to login & recieve an[/color][/color][/color]
exta[color=blue][color=green][color=darkred]
> > > option of being able to list CD's in order of interest (no of hits per[/color][/color]
> CD,[color=green][color=darkred]
> > > so to speak)
> > >
> > > Note - The database is in MS Access (no relations have been created)
> > >
> > > Can anyone provide me good content-specific links that will help me[/color][/color][/color]
this[color=blue][color=green][color=darkred]
> > > Thank you.
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]