list into query

[Guest]

I have a list of checkbox values. I am checked multiple checkbox and I want to pass this value in my query.
I used preservesinglequote but it didn't put quotes.

How can i build list and then pass in query

for example IN ('A','B')

thanks

[insuractive]

use <cfqueryparam>:

WHERE myField in (<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#Form.myCheckbox#" list="Yes")>