Populate Drop Down with cfquery

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