Multiple Related Selects

[Lucky_Kitty]

I'm trying to create three related select boxes. I want the user to make a selection in box one, and then display data in box two based upon their selection from box one, etc. I don't want the page to refresh. I'm on ColdFusion 7. Here's the code I'm trying, but I can't get data into box two or three. Any suggestions?

[Guest]

You might want to take a look at http://www.javascripttoolbox.com/lib/dynamicoptionlist/

[Lucky_Kitty]

Those are nice and work good, but the values are hard coded. I'm strugging with how to fill the values from the database AND make the selects dependent upon each other. Do you know where there's a sample that has the array populated from database values?

[Lucky_Kitty · Accepted solution]

CF_ThreeSelectsRelated is AWESOME! Works Great. Does exactly what I needed.

http://www.adobe.com/cfusion/exchange/index.cfm?event=extensionDetail&loc=en_us&extid=1000298

[Guest]

You can download Xin Yang's JavaScripts from http://www.dynamicdrive.com/ and dynamically populate the exampleconfig2.js from a CFQUERY. Yang's code may be overkill, but it is a classic in the world of JavaScript.