<div>
Works perfect! Thanks _agx_.
</div>


<div>
<div class="content wysiwyg-content">
I have added &quot;multiple&quot; to my select dropdown, but I'm not sure how to adjust my SQL query on the action page to compensate for multiple city selections? Any help appreciated!<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2013/06_w25/661236/multipleselect.png" target="_blank" title="screenshot of multiselect menu (8 KB)"><img alt="screenshot of multiselect menu" class="file-block lazyload" style="max-width: 596px;" data-src="https://filedb.experts-exchange.com/incoming/2013/06_w25/661236/multipleselect.png" /></a><br />
&lt;cfselect name = &quot;City&quot; query = &quot;city&quot; value = &quot;City&quot; queryPosition=&quot;below&quot; selected = &quot;#prefillCity#&quot; class=&quot;selectpicker show-menu-arrow span6&quot; multiple&gt;<br />
&nbsp; &nbsp; &nbsp; &lt;option value=&quot; &quot;&gt;All Cities&lt;/option&gt;<br />
&nbsp; &nbsp; &nbsp; &lt;/cfselect&gt;<br />
<br />
<br />
&lt;!---QUERY ON FORM ACTION PAGE---&gt;<br />
&lt;cfquery name=&quot;listings&quot; datasource=&quot;datasource&quot; result=&quot;result&quot;&gt;<br />
SELECT * from res INNER JOIN seo on res.Listid = seo.Listid <br />
WHERE 0=0<br />
<br />
&lt;!---Search by City---&gt;<br />
&lt;cfif StructKeyExists(form,&quot;City<wbr />&quot;) and len(trim(form.City))&gt;<br />
&nbsp;AND City = '#form.City#'<br />
&lt;/cfif&gt;
</div>
</div>


multipleselect.png

I have added "multiple" to my select dropdown, but I'm not sure how to adjust my SQL query on the action page to compensate for multiple city selections? Any help appreciated!



<cfselect name = "City" query = "city" value = "City" queryPosition="below" selected = "#prefillCity#" class="selectpicker show-menu-arrow span6" multiple>
      <option value=" ">All Cities</option>
      </cfselect>



<cfquery name="listings" datasource="datasource" result="result">
SELECT * from res INNER JOIN seo on res.Listid = seo.Listid 
WHERE 0=0


<cfif StructKeyExists(form,"City") and len(trim(form.City))>
 AND City = '#form.City#'
</cfif>

Coldfusion Form submit / SQL question

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

ColdFusion Language

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.