You can preload all of the cities and all of the countries using JavaScript
to get instant changes. This may take a while longer for the page to
display on the users end. Or you could write a javascript that
automatically submits the form to itself after changing the drop down list
value that then pulls the city data from the database and displays the same
page again with the new cities.
--Greg
----- Original Message -----
From: "Cornillon, Matthieu" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 02, 2001 2:07 PM
Subject: dynamic form controls
> Happy new year, everyone.
>
> I have a form with a couple of drop down controls. I'll call them
> dd_country and dd_city. I would like the contents of dd_city to be based
on
> the contents of dd_country. If the user selects France, the dd_city
should
> hold Paris, Marseilles, Nice. If the user selects Italy, the dd_city
should
> hold Florence, Rome, Venice, Ortisei. Etc.
>
> I know how to set up the database and do the lookup, but I don't know how
to
> make this happen on the fly. I cannot do the lookup for dd_city until the
> user selects a value from dd_country. Aside from setting these up as
> separate pages, is there a non-convoluted way to do this? I considered
> having the page drill down to itself on dd_country's onChange event,
feeding
> back in the value of dd_country, but that gets messy for other reasons.
>
> Any thoughts?
>
> Thanks in advance,
> Matthieu
>
>
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
