cfquery and list form

[ky_loh]

Greeting!

I have a form that submit MULTIPLE list from the <select> tag. When the list
had send to action page, I need to run <cfquery> for retrieve data that match
the contents inside the list.

Example:

The value from the list : 2, 7, 10, 13

How should I write my query??

should I write

<cfquery name=query datasource=db>
select * from tableA
where items = <contents only match the list>
</cfquery>

The result shoudl only show "items" equal to 2 or 7 or 10 or 13 only....

I had stuck here....HELP ME!!!!

Thank you.

[The ScareCrow]

where items IN (<contents only match the list>)

Ken

[ky_loh]

The list is passing the value through the multiple selection form tag <select
multiple>

so when the user select a few item in the form anc click "submit"
my display page should run query that refering only the particular values
only.....

[ky_loh]

ok..........................................i get it...thank you