ASP Help needed

Discussion in 'ASP General' started by *** HAWK, Nov 20, 2003.

  1. *** HAWK

    *** HAWK Guest

    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.
    *** HAWK, Nov 20, 2003
    #1
    1. Advertising

  2. *** HAWK

    Steven Burn Guest

    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 <> wrote in message
    news:3fbcb2a3$0$2393$...
    > 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.
    >
    >
    Steven Burn, Nov 20, 2003
    #2
    1. Advertising

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

    "*** HAWK" <> wrote in message
    news:3fbcb2a3$0$2393$...
    > 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.
    >
    >
    William Morris, Nov 20, 2003
    #3
  4. *** HAWK

    *** HAWK Guest

    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" <> wrote in message
    news:bpiirg$1n2fpj$-berlin.de...

    > Sounds like a perfectly reasonable program spec to me...what exactly do

    you
    > need help on?
    >
    > "*** HAWK" <> wrote in message
    > news:3fbcb2a3$0$2393$...
    > > 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.
    > >
    > >

    >
    >
    *** HAWK, Nov 21, 2003
    #4
  5. *** HAWK

    *** HAWK Guest

    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" <> wrote in message
    news:3fbe1826$0$24060$...
    > 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" <> wrote in message
    > news:bpiirg$1n2fpj$-berlin.de...
    >
    > > Sounds like a perfectly reasonable program spec to me...what exactly do

    > you
    > > need help on?
    > >
    > > "*** HAWK" <> wrote in message
    > > news:3fbcb2a3$0$2393$...
    > > > 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.
    > > >
    > > >

    > >
    > >

    >
    >
    *** HAWK, Nov 21, 2003
    #5
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. jm
    Replies:
    3
    Views:
    378
    Kevin Spencer
    Jan 21, 2004
  2. Thomas Nick
    Replies:
    0
    Views:
    1,873
    Thomas Nick
    Jun 13, 2005
  3. Ryan Macy

    Ideas needed & help needed!

    Ryan Macy, Jul 19, 2006, in forum: Ruby
    Replies:
    2
    Views:
    500
    Ryan Macy
    Jul 19, 2006
  4. LeTubs
    Replies:
    6
    Views:
    117
    Tad McClellan
    Jan 25, 2004
  5. John Farold
    Replies:
    0
    Views:
    383
    John Farold
    Aug 29, 2012
Loading...

Share This Page