We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Database access

gbr
gbr asked
on
Medium Priority
235 Views
Last Modified: 2010-04-09
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.
Comment
Watch Question

Commented:
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.





Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.