I have an htm page that has an image map on it. I want to be able to click onto part of the image and bring up specific parts of a database.
ie: I click on North America in the map, and all the north america records come up. I have made the image map, the database and the asp page that brings the records up for all the records. in the database the location is called "location" and the region is called "area" the location would be the record set of all the locations in the region, the region being "na" for North America, "sa" for South America etc.
I need to know:
how to select one region, and get only that regions records up.
I am sure this is done using a case statement however My knowledge is limited in ASP so please be specific in an explaination. if you give a sample for just north america I can do the rest of them by myself. please help me
Mitch
Phoenix, AZ
ie: I click on North America in the map, and all the north america records come up. I have made the image map, the database and the asp page that brings the records up for all the records. in the database the location is called "location" and the region is called "area" the location would be the record set of all the locations in the region, the region being "na" for North America, "sa" for South America etc.
I need to know:
how to select one region, and get only that regions records up.
I am sure this is done using a case statement however My knowledge is limited in ASP so please be specific in an explaination. if you give a sample for just north america I can do the rest of them by myself. please help me
Mitch
Phoenix, AZ