Link to home
Start Free TrialLog in
Avatar of gbr
gbr

asked on

Database access

I am pretty new to the area of web development, and I am working on a simple project to retrieve info from an access db and display it. Basically, I need to populate a combo box with a list of countries from the Country table, the user then selects a country which I then use to retrieve a list of cities and populate another combo box.  I need guidance on how I construct this and possible some sample code to do this, ...HTML seems very different to usual VB programming which I have been doing for the last 4 years.  Thanks.
Avatar of sybe
sybe

It can be done (i have done it), but it is not so easy to write it down in a few words.

I have used ASP (Active Server Pages) to get the data from the database. Then I used javascript to change the second combobox according to the choice made in combo #1.

In this case it all work in one page, in NS3+ en IE4 (IE3 does not have enough javascript capacities).

It also can be done using 2 ASP pages, in which the first page (with the country choice) calls the second (with the city choice).

ASP is not so very different from VB, as it uses VB-script, at least it should look familiar to you :)

Anyway, it seems no use to give my answer if you are not running ASP. So that is my first question to you.





ASKER CERTIFIED SOLUTION
Avatar of sybe
sybe

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial