473,320 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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.
Jul 19 '05 #1
4 1643
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 <no*********@INVALID.mail.com.Invalid> wrote in message
news:3f**********************@news.dial.pipex.com. ..
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.

Jul 19 '05 #2
Sounds like a perfectly reasonable program spec to me...what exactly do you
need help on?

"*** HAWK" <no*********@INVALID.mail.com.Invalid> wrote in message
news:3f**********************@news.dial.pipex.com. ..
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.

Jul 19 '05 #3
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" <NO**************@seamlyne.com> wrote in message
news:bp*************@ID-205671.news.uni-berlin.de...
Sounds like a perfectly reasonable program spec to me...what exactly do you need help on?

"*** HAWK" <no*********@INVALID.mail.com.Invalid> wrote in message
news:3f**********************@news.dial.pipex.com. ..
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.


Jul 19 '05 #4
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" <no*********@INVALID.mail.com.Invalid> wrote in message
news:3f***********************@news.dial.pipex.com ...
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" <NO**************@seamlyne.com> wrote in message
news:bp*************@ID-205671.news.uni-berlin.de...
Sounds like a perfectly reasonable program spec to me...what exactly do you
need help on?

"*** HAWK" <no*********@INVALID.mail.com.Invalid> wrote in message
news:3f**********************@news.dial.pipex.com. ..
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.



Jul 19 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: System | last post by:
Hello All, Redhat 9.0 Mysql 3.23.56 ==> Running I want to upgarde to 4.0.13 but this is the error it says: # rpm -Uvh MySQL-server-4.0.13-0.i386.rpm warning: MySQL-server-4.0.13-0.i386.rpm: V3...
8
by: Stephen | last post by:
I am trying to add some code to below to include a datatable and fill the datatable. The reason for doing this is so as I can check to see whether there are any rows returned by the stored...
13
by: Joe Feldman | last post by:
This position is located in the South Bay Area in Northern California. If you are interested please send me your resume in a word .doc so that I can review it. If this does not look like a match,...
0
by: Cindy B | last post by:
Please send your resume and position to Cindy@AtlanticResource.com! I CAN NOT accept candidates that ARE OUTSIDE OF THE US! NO PHONE CALLS PLEASE! Email your resume to me! Position:SQL...
3
by: Wade | last post by:
I would like to install the .Net 1.1 framework on a Web Server running W2K to be able to run ASP.NET files, but I'm not sure where to find the files I need for the .Net framework. I have ".NET...
17
by: dingoatemydonut | last post by:
The C99 standard states: "In the abstract machine, all expressions are evaluated as specified by the semantics. An actual implementation need not evaluate part of an expression if it can deduce...
5
by: Steve | last post by:
Hi, I am sitting down to design our next set of internal apps. I would like to approach this in a way that would allow me to break logical parts of the application that handle specific tasks...
0
by: ultradiv | last post by:
I have a VB.NET application partly built that produces an xml output (just a file at present) I have a .NET webserver and SQLserver 2000 I need to be able to send the xml to the webserver/database...
28
by: Ian Davies | last post by:
Hello I would appreciate some help from someone who has knowledge of working with css, php javascript and how they interact. Ive been working on a task for the last few days and have started to...
37
by: C_guy | last post by:
Does anyone know of a (hopefully free) tool that can traverse a project and determine which "#include"s are not needed or needed in every .C file? This would be helpful in removing header...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.