ColdFusion + Javascript - 2 Dynamic Drop Down Boxes

Here is another EE topic with the same topic in the coldfusin forum.
http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_21536325.html

Urgh, they are all messy and lead on to about 3 other posts.  Is there actually a post with the code in to do it in ColdFusion anywherE?

Sorry, the CF Link actually has links to three methods. None of these are trivial.
Here is the Javascript method:
http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_21268362.html
--- it actually has links to CF custom tag code also that should simplify this, but I didn't dig into it...

Here is a link to a method drawn up by mrichmon that shows how to submit queries in the background to dynamically change the lists
http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_20936125.html

The last method that is mentioned is to use CFAJAX, but they don't really provide details on how to do this specifically.
http://www.indiankey.com/cfajax/
I believe it is related to this method. http://www.indiankey.com/cfajax/examples/list.htm

What you are wanting is not trivial and is going to take a lot of code. It doen't make sense to try and paste all that code into another link and the best that is going to happen is for someone just to copy code from one of these other links...

I wrote this a while ago so it's not pretty, but it got the job done.  I modified it a little to try and fit your request so forgive any typos :-)

<cfset CountyQry = QueryNew("CountyID,County_name,CountryID","Integer,varchar,integer")>
<cfoutput query="counties">
  <CFSET QueryAddRow(CountyQry,counties.currentrow)>
  <Cfset QuerySetCell(CountyQry,"CountyID",counties.ID)>
  <Cfset QuerySetCell(CountyQry,"County_name",counties.NAme)>
  <Cfset QuerySetCell(CountyQry,"CountryID",counties.CountryID)>
</cfoutput>

<script type="text/javascript">
function chgcounty(SelCountry){
var SelCounty;
var SelCountry;
SelCounty = document.myformname.counties;
<cfloop query="pull_country">
if(SelCountry == "#pull_country.country_id#"){
SelCounty.options.length = countyQry.recordcount#+1;
<Cfquery dbtype="query" name="cnty">
      SELECT CountyID,County_name,CountryID
      FROM CountyQry
      WHERE CountryID = #pull_country.country_id#
      ORDER BY County_Name
</CFQUERY>
<cfloop query="cnty">
  SelCounty.options[cnty.currentrow] = new Option("#cnty.county_name#","#cnty.CountyID#");
</cfloop>
}
</cfloop>
}
</script>

<select name="countries" onchange="chgcounty(this.options[this.selectedIndex].value">
      <cfloop query="pull_country">
        <option value="#pull_country.id#">#pull_country.Country_Name#
      </cfloop>
</select>

<select name="counties">
      <option value="">
</select>


I took some liberties, like assuming your County DB table has the country ID, assuming the name of your FORM, etc...

May need a little configuring on your side but should help.

Good luck

Oops, just noticed my own typos...

First, the whole of the JAvaScript should be in a set of CFOUTPUT tags and this line:
SelCounty.options[cnty.currentrow] = new Option("#cnty.county_name#","#cnty.CountyID#");

should be:

SelCounty.options[#cnty.currentrow#] = new Option("#cnty.county_name#","#cnty.CountyID#");

Good luck

I'm trying to use your code but I get this error ...

Error Occurred While Processing Request  
There is no column in the query object.  
 
Here's the code:

<cfquery NAME="pull_country" DATASOURCE="#application.appdsn#">
SELECT country_id, country
FROM countries
ORDER BY country
</cfquery>

<cfquery NAME="pull_locations" DATASOURCE="#application.appdsn#">
SELECT county_id, county, country_id
FROM counties
ORDER BY county
</cfquery>

<cfset CountyQry = QueryNew("county_id,county,country_id","Integer,varchar,integer")>
<cfoutput query="pull_locations">
  <CFSET QueryAddRow(CountyQry,pull_locations.currentrow)>
  <Cfset QuerySetCell(CountyQry,"CountyID", county_id)>
  <Cfset QuerySetCell(CountyQry,"County_name", county)>
  <Cfset QuerySetCell(CountyQry,"CountryID", country_id)>
</cfoutput>


<CFOUTPUT>
<script type="text/javascript">
function chgcounty(SelCountry){
var SelCounty;
var SelCountry;
SelCounty = document.myformname.counties;
<cfloop query="pull_country">
if(SelCountry == "#pull_country.country_id#"){
SelCounty.options.length = #countyQry.recordcount#+1;
<Cfquery dbtype="query" name="cnty">
     SELECT CountyID,County_name,CountryID
     FROM CountyQry
     WHERE CountryID = #pull_country.country_id#
     ORDER BY County_Name
</CFQUERY>
<cfloop query="cnty">
  SelCounty.options[#cnty.currentrow#] = new Option("#cnty.county_name#","#cnty.CountyID#");
</cfloop>
}
</cfloop>
}
</script>

<select name="countries" onchange="chgcounty(this.options[this.selectedIndex].value">
     <cfloop query="pull_country">
       <option value="#pull_country.country_id#">#pull_country.country#</option>
     </cfloop>
</select>

<select name="counties">
     <option value="">
</select>
</CFOUTPUT>