I have what seems like a simple job to do- but ...

I basically want to know if DW is capable of helping me achieve the following and if so- any good step by step guides out there?

I have 3 pull down menus. I am using DW cs3 and have the developers toolbox (though not very sure how to work that yet!). I have the database set up using phpmyadmin. I am also able to do the recordsets etc and make the Mysql connecitons okay. However it is the DYNAMIC POPULATION of the 2nd and 3rd drop downs that are causing me probs.

When someone clicks on a choice from the first pull down I want that initial choice from the 1st drop down to load data into the 2nd pull down. And when they make a selection from the 2nd pull down- I want the 3rd pull down to then load with the correct data in terms of the previous selection.

Please someone put me out of my misery- I have searched safari books for days and just can't seem to get the step by step guide my tiny mind needs.

Pulldown1= country
Pulldown2= city
Pulldown3= town

Can anyone point me in the right direction? I will be grateful in this life and the next!
Christine

Hi Christine,
I have not done this myself - yet <img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

But I have seen discussion about it elsewhere, try this post

forums.devarticles.com/cold-fusion-development-18/populating-drop-down-based-on-another-drop-down-3843.html

if you search for 'populate dropdown based on dropdown' (without the quotes) you will come up with lots of ideas, basically I don't think this is an easy thing to do without ajax, or swapping pages.

Good luck <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Thanks Alan. I have found some useful stuff thanks to you. If i ever mange it I will share it gladly...

Christine

Mr christine

Tell me the process if you found

Sikander

I'm still bashing my head against the wall... The problem is I want to use dynamic population from a database. Eg onchange the selection populates the next dropdown by retrieving it from the database. I did find an example where you can manually add all the options and the lists populate from the selection so you might find that helpful. You can find it at
www.javascriptkit.com/script/script2/triplecombo.shtml Maybe you will find it helpful.

Christine

Any way thanx alot for sharing with me

but this concept is covered in Cold Fusion 8

We can do this by creating CFC's

Sikander