CFQuery inside of a loop

Change the form to get rid of the quotes.

On your action page, try using cfqueryparam with the list attribute set to yes.

Dan,

url.region looks like 'Africa' if single selected, or 'Africa','Asia' if multi-selected. At least that's what shows up in a cfdump. Region_id is an integer type column.

I should note that the actual url.region comes in as 'Africa,Asia' when multi-selected but I'm using ListQualify to create the single tick list for use in the IN clause for the query. Not sure if that makes a difference in the solution here. More precisely, url.region would still be 'Africa,Asia' but I'm putting that into regionList2 as value 'Africa','Asia'.

What I'm trying for is pretty much the following:

<cfif IsDefined('url.region')>
<cfset regionList2 = ListQualify(url.region,"'",",","all")>
<cfset regionList3 = ''>
<cfloop index="i" from="1" to="#ListLen(regionList2)#">
<cfquery name="GetRegionID" datasource="#myDB#">
select region_id from region
where region_name IN (#PreserveSingleQuotes(regionList2(trying to put bracket i close bracket here))#)<!---THIS is problem area--->
</cfquery>
<cfset regionList3 = regionList3 & '#GetRegionID.region_id#'>
</cfloop>
</cfif>

Thanks for the response and huge thanks in advance if you can help on this :).

Dave

What exactly does url.region look like? Also, is region_id a numeric or char field in your db?