Skip to main content
Z
ZNB
Inspiring
June 5, 2018
Question

related drop-down lists

  • June 5, 2018
  • 1 reply
  • 477 views

I have two dropdown lists whose contents are extracted from a database.

But I would like that when I select a value in the first, the content of the second adjusts because according to the choice in the first list, I will not have the same elements in the second.

illustration: display the department of a selected region. So I have a database with two tables, a table for the regions, a second for the departments. By selecting a region in the first list, I will display the second list corresponding to the departments of the selected region.

Tank you

    This topic has been closed for replies.

    1 reply

    WolfShade
    WolfShade
    Legend
    June 5, 2018

    Easy to do, but it won't be a strictly CF solution.  You have to use JavaScript (or jQuery) to do it.

    Basically, you load the page with the first select fully populated by the database.  The second select should have no options.

    Set the onChange of the first select to use AJaX to make the call to a .cfm or .cfc that will get the related department based upon the value of the region select, and then add the options to the second select.

    HTH,

    ^ _ ^

    Z
    ZNBAuthor
    Inspiring
    June 6, 2018

    Do you have an example for this to be more meaningful?

    cordially

    WolfShade
    WolfShade
    Legend
    June 6, 2018

    Hi, ZNB,

    Raymond Camden has an excellent blog post about related selects.  This example is using jQuery.

    https://www.raymondcamden.com/2011/05/05/Related-selects-in-jQuery-an-example

    HTH,

    ^ _ ^

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices