2 Replies Latest reply on Nov 22, 2009 9:51 AM by emmim44

    Populate Drop Down with cfquery

    emmim44 Level 1

      Hi all,

       

      I need to populate my hub select box based on division select box then populate node based on the selection of hub. I know this is combination of js and cf. I dont want f5 the screen though. Thank u all.

       

      Division list:

       

      select  distinct DIVISION

      from    OPS$NEW.REF_DIVISION

       

      HUB List:

       

      select  distinct b.HUB

      from    OPS$NEW.REF_DIVISION    a,

              OPS$NEW.SUB_COUNT       b

      where   a.PRIN          = b.PRIN

      and     a.DIVISION      = < DIVISION>

      order   by 1

       

      NODE List:

       

      select  distinct b.NODE

      from    OPS$NEW.REF_DIVISION    a,

              OPS$NEW.SUB_COUNT       b

      where   a.PRIN          = b.PRIN

      and     a.DIVISION      = < DIVISION>

      and     b.HUB           = <HUB>

      order   by 1