Populating drop down based on another drop down

Here is what I'm triing to do.

I have a database with a state table and a province table... witch are linked.

I have to drop down menus, 1 for the state, and one for the city.

I want to fill the one with city's based on what was given to me in the state drop down.

I know how to do it with coldfusion and refresh the page with a new query. But I want to do it without refreshing the page. There will be probably javascript involved.

Thank you

Yes, you'll need Javascript to do it.

I've just implmented the same thing on a client's site.. it's a bit of a nightmare to do, as it causes all sort of problems if the user hits the back button to get back to the page (their selections aren't saved, and u get JS errors....)

anyway - here's the site , simply view source and have a poke around.

Also, here's a link to some source: http://www.js-examples.com/example/?ex=683&mode=2

Take a look at www.fusionscript.com it has the ability to dynamically populate drop downs without refreshing the page.

These javascripts will have your answers. username: resources; password: resources, view source. Here are the links:

http://www.bestwebatlanta.com/resou...pdown_boxes.htm

http://www.bestwebatlanta.com/resou...ation_smart.htm

http://www.bestwebatlanta.com/resou...ation_smart.htm

http://www.bestwebatlanta.com/resou...pdown_smart.htm

Good luck!
Frasier

I was looking at this question and I remembered an article my company published a while back....
This script is better for longer lists and uses mentions PHP but it should work with all other server side languages. This is for pages that need the triple combo box idea but could really be simplified by doing direct server queries. A warning is that this technique does require newer browsers and JS enabled... But it could save some people hours. It has a live demo if you want to see it in action too
http://www.transparen.com/en/howto-refresh-page-parts
Kyle

I have seen several ways in coldfusion to accomplish this, but the easiest I think is using this third party software called MXWidgets built by "Interakt". its actually pretty nice, although I have been using some custom cftags that came from "CFTagStore" Related Selects (Cross Browsers) - cf_select but had some problems using dynamic from a simple access db, After Rizal fixed this, it was the nutts, so I choose to stay with this, considering I have already bought it. And WebAssist has a dependant dropdown for coldfusion also, haven't seen the code but, well, I am sure they are good too. there are 2 related selects and 3 multiple selects that I seen some where and have somewhere that is free. Plus what I use does not refresh the browser, which is nice.



http://www.webassist.com/Products/Samples/1Sample.asp?PID=1
http://www.interaktonline.com/Products/Dreamweaver-Extensions/MXWidgets/Benefits/Details/Dependent+Drop-downs.html?id_sol=16
http://www.cftagstore.com/tags/related.cfm

May i have those code in coldfusion, cause i'm trying to do the same thing right here at my office ...it would be much more appreciate it ..if u can pass over the code to me ...for the dual downdown ..

I need to do this I usually generate all my necessary lists when the page loads and set the visibilities to hidden, then based on the other drop-down selection I show the proper list.

Works great, and not a whole lot of JS involved.

i have two drop down boxes when i am selecting value from fisrt drop down the value in second drop down has to change accordingly without page refreshing can u pls give the sample code if u have bcos i have tried it many times