Web Development

Ask something
Discussion Locked

Can anyone help me with ASP scripting?

0 helpful
2 replies

by maryvincent

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have created a Database(Access 2000) called Restaurants, containing 3 tables named:
CITIES - (fields) > city_id*, city_name, city_comment
RESTAURANTS >city_id, rest_id, rest_name*, rest_cuisine
REST_INFO >rest_name, address, capacity, specialities

fields city_id in CITIES and rest_name in RESTAURANTS are key fields.

The Relation I created is city_id in CITIES to city_id in RESTAURANTS whose rest_name field is in turn related to rest_name in REST_INFO.

What scripting do I need to get one ASP page to show a list of all the cities, and when a city is clicked get the restaurants for that city listed which in turn are links to the info on the particular restaurant.

I assume I will need three .asp pages:
cities.asp, restaurants.asp and rest_info.asp, but
I really have no idea how to go about creating them.

I would really appreciate any help.

2 replies

by marvinmarshall

I hope the following will help:

On cities.asp page, make following link:

">......

For restaurants.asp page:

use the following to retrive the city_id

dim city_id = request.querystring("city_id")

now use city_id to search the resturant table and display the result

do the same for rest_info.asp page

visit the following site for more info and help:
http://www.w3schools.com/asp/default.asp

This discussion is closed to new replies.