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

Posted on 2009-04-02
Medium Priority
Last Modified: 2013-12-24
I am attempting to bind a cfselect to show the cities that are in the state they select on a cfform.


<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 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
      <!--- Convert results to array --->
      <cfloop index="i" from="1" to="#data.RecordCount#">
         <cfset result[i][1]=Data.city[i]>
      <!--- And return it --->
      <cfreturn result>

Open in new window

Question by:LeadCo
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 27

Accepted Solution

azadisaryev earned 2000 total points
ID: 24057001
first, you no longer need to convert the query to an array an return that array from your cfc function - CF8 supports plain old query to populate your cfselect.
so you can change your cfc function to a simple:

<cffunction name="cityfind" access="remote" returnType="QUERY">
  <cfargument name="state" type="string" required="true">
  <!--- Define variables --->
  <cfset var data="">
  <!--- Get data --->
  <cfquery datasource="#THIS.dsn#" name="data">
  SELECT city
  FROM Zipcodeworld
  WHERE state = <cfqueryparam cfsqltype="cf_sql_varchar" value="#ARGUMENTS.state#">
  <cfreturn data />

> I have no idea how to show values in drop down with cfc

by using DISPLAY and VALUE attributes and specifying in them a query column (city for both in your case, since your query returns one column only):

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


Author Comment

ID: 24057129
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.....
LVL 27

Assisted Solution

azadisaryev earned 2000 total points
ID: 24057669
oh, right, cfselect must have a closing </cfselect> tag for this to work - it does not work with <cfselect .. /> syntax:

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


Author Closing Comment

ID: 31566124

Featured Post

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi. There are several upload tutorials using jquery and coldfusion. I found a very interesting one here Upload Your Files using Jquery & ColdFusion and Preview them (http://www.randhawaworld.com/) . I did keep the main js functions but made sever…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question