asked on

How do I: Cfform- cfselect- bind - Show cities in a drop down when state is selected

I am attempting to bind a cfselect to show the cities that are in the state they select on a cfform.

form:

<cfselect name="state" size="1" id="state"class="style3">
                                                                          <option value="Select" selected>Select State</option>
                                                                          <option value="AK">AK</option>
                                                                          <option value="AL">AL</option>
                                                                          <option value="AR">AR</option>
                                                                          <option value="AZ">AZ</option>
                                                                          <option value="CA">CA</option>
                                                                          <option value="CO">CO</option>
                                                                          <option value="CT">CT</option>
                                                                          <option value="DC">DC</option>
                                                                          <option value="DE">DE</option>
                                                                          <option value="FL">FL</option>
                                                                          <option value="GA">GA</option>
                                                                          <option value="HI">HI</option>
                                                                          <option value="IA">IA</option>
                                                                          <option value="ID">ID</option>
                                                                          <option value="IL">IL</option>
                                                                          <option value="IN">IN</option>
                                                                          <option value="KS">KS</option>
                                                                          <option value="KY">KY</option>
                                                                          <option value="LA">LA</option>
                                                                          <option value="MA">MA</option>
                                                                          <option value="MD">MD</option>
                                                                          <option value="ME">ME</option>
                                                                          <option value="MI">MI</option>
                                                                          <option value="MN">MN</option>
                                                                          <option value="MO">MO</option>
                                                                          <option value="MS">MS</option>
                                                                          <option value="MT">MT</option>
                                                                          <option value="NC">NC</option>
                                                                          <option value="ND">ND</option>
                                                                          <option value="NE">NE</option>
                                                                          <option value="NH">NH</option>
                                                                          <option value="NJ">NJ</option>
                                                                          <option value="NM">NM</option>
                                                                          <option value="NV">NV</option>
                                                                          <option value="NY">NY</option>
                                                                          <option value="OH">OH</option>
                                                                          <option value="OK">OK</option>
                                                                          <option value="OR">OR</option>
                                                                          <option value="PA">PA</option>
                                                                          <option value="RI">RI</option>
                                                                          <option value="SC">SC</option>
                                                                          <option value="SD">SD</option>
                                                                          <option value="TN">TN</option>
                                                                          <option value="TX">TX</option>
                                                                          <option value="UT">UT</option>
                                                                          <option value="VT">VT</option>
                                                                          <option value="VA">VA</option>
                                                                          <option value="WA">WA</option>
                                                                          <option value="WI">WI</option>
                                                                          <option value="WV">WV</option>
                                                                          <option value="WY">WY</option>
                                                                          <option value="ZZ">ZZ</option>
                                                                          </cfselect>
 
<cfselect name="city"
            bind="cfc:citylookup.cityfind({state})" />
 (I have no idea how to show values in drop down with cfc)
 
 
 
CFC: citylookup.cfc
 
<cfcomponent output="false">
 
<cfset THIS.dsn="mydsn">
 
   <cffunction name="cityfind" access="remote" returnType="array">
      <cfargument name="state" type="string" required="true">
 
      <!--- Define variables --->
      <cfset var data="">
      <cfset var result=ArrayNew(1)>
      <cfset var i=0>
 
      <!--- Get data --->
      <cfquery datasource="#THIS.dsn#" name="data">
      SELECT city
      FROM Zipcodeworld
      WHERE state = '#ARGUMENTS.state#'
      ORDER BY City
      </cfquery>
   
      <!--- Convert results to array --->
      <cfloop index="i" from="1" to="#data.RecordCount#">
      
         <cfset result[i][1]=Data.city[i]>
 
      </cfloop>
 
      <!--- And return it --->
      <cfreturn result>
   </cffunction>

Open in new window

ASKER CERTIFIED SOLUTION

azadisaryev

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

LeadCo

ASKER

HMMMMM. I used that exact code and it did not place values in city cfselect after selecting a state.

I tried.

<cfselect name="city" bind="cfc:citylookup.cityfind({state})" DISPLAY="city" VALUE="city" />

<cfselect name="city" bind="cfc:citylookup.cityfind({state})" DISPLAY="data.city" VALUE="data.city" />

<cfselect name="city" bind="cfc:citylookup.cityfind({state})" DISPLAY="result.city" VALUE="result.city" />

No Luck.....

SOLUTION