I have a cfquery-tag and I want to use a variable in the sql-statement.
<CFQUERY NAME = "Parztype" DATASOURCE = ds_t>
select count(*) number, type, trunc(sum(area),1) area
where section in #gem#
group by type
I can output the #gem# and it looks like: ('1', '2', '3A', '5X') incl. the parenthesis. But the select-statement does not work. In an other part I have a: section = #sec# where #sec# = '3A' and this works.
Does anybody have an idea whats wrong?
Thanks for any help