I am using a routine to build a variable called "regions" which can be any
combination of 1,2,3 depending on the user's selection of sales regions. So
regions could be just 1 or 1,3 or 1,2,3.
I want to use a variable built with concatenation called #regions# in the
<cfquery dbtype="query" name="detail5">
where region IN (#regions#);
Using CFOUTPUT the string appears correct i.e. '1','2','3' or other variation
but always correctly formed. HOwever using the variable throws an error.
Query Of Queries syntax error.
Encountered "region IN ( \'\' 1" at line 0, column ...