Using mulitple selections from drop-down

[Biglop]

I have a simple dynamically populated drop-down on a form page...Code:

<form method=&quot;POST&quot; action=&quot;search_process.cfm&quot;>
<p>State: <input type=&quot;text&quot; name=&quot;State&quot; size=&quot;20&quot;>

<p>Focus Area:<select size=&quot;1&quot; Name=&quot;ls_focus_ID&quot; multiple=&quot;yes&quot;>
<OPTION SELECTED VALUE=&quot;&quot;>Choose One
<cfoutput query=&quot;focus_areas&quot;>

<OPTION VALUE=&quot;#ls_focus_ID#&quot;>#Focus#
</cfoutput>

</select>


And an action page where I want to display the results of this query. Each group can have multiple &quot;focus areas&quot;.

I allow multiples to be selected, but I'm not sure how to deal with the results on the action page. will I have to loop somehow? Action page code below:

<CFQUERY
DATASOURCE=&quot;outreach&quot;
NAME=&quot;groups_found&quot;>

SELECT DISTINCT Organization_1, City, Street_address_1, State, Postal_Code
FROM Main_Table, LS_Details, LS_Focus_Areas
WHERE State = '#Form.State#'
AND Main_Table.LS_ID = LS_Details.LS_ID
AND LS_Details.ls_focus_ID = #Form.ls_focus_ID#
ORDER BY Organization_1

</CFQUERY>