i am new need help

cfnew,

I would use cfselect, and "bind" the selects together.  If you're new to cf, read up on "bind", just so you're somewhat familiar with what I'm doing here.  Here is basically what happens.

1).  You write the query that is going to populate the first select box, *I happen to use cffunction within a cfc, or cfcomponent. To bind, you have to use a cfc.

2).  Once you've made your first selection, the bind function on the second cfselect is going to take the input from the first select, and use it to gather the information to populate the second cfselect. i.e. your second query.

You can repeat this for as many select boxes as you have.

Here is an example of the cfselects and how their linked together:

<!---  Notice the value = Category, this is the output variable, your user will be selecting this first.

        Notice the bindonLoad, only on the first one.  When your page loads, this tells the page to load this select box *use on your first one only. --->

<cfselect
     name="Category"
     bind="cfc:quad.GetCategory()"
     style="width:387px;"
     size="1"
     multiple="No"
     required="No"
     display="Category"
     value="Category"
     bindonLoad="True">
</cfselect>

<!---  Notice here the bind, you're calling the second query here.  Category is what was selected from the first select box.  This is the "Argument" that comes over into your cffunction. You'll end up passing this argument into your query, most likely in the WHERE clause --->
                  
<cfselect
     name="Channel"
     bind="cfc:quad.GetChannel({Category})"
     tyle="width:387px;"
     size="1"
     multiple="No"
     required="No"
     display="Channel"
     value="Channel">
</cfselect>

<!---  Notice here the bind, you're calling the third query here.  Category (first selection), and Channel (second selection).  They both become Arguments into your third cffunction.  You'll need three functions, one to call the first cfselect, the second, and the third.  The queries may be somewhat the same, but the WHERE clause is probably taking more and more Arguments. --->

           
<cfselect
      name="Region"
      bind="cfc:quad.getRegion({Category},{Channel})"
      style="width:387px;"
      size="1"
      multiple="No"
      required="No"
      display="Region"
      value="Region">
</cfselect>

Hope this helps!

<cfwild />

What you are attempting is called related selects.  If you google "coldfusion related selects" you will find that there are more than one way to achieve it.  I use the method described here:

http://www.pathcom.com/~bracuk/code/RelatedSelects.htm