multiple select list problem

i have a CFSELECT used in a search that works fine when only one attribute is selected for search... here are the two pieces of code, the first is from the input form, the second is from the SQL search query...

<CFSELECT name="category" multiple="yes" size="4">
<OPTION value="">----------
<CFOUTPUT query="categoryQuery">
<OPTION value="#Category#">#Category#
</CFOUTPUT>
</CFSELECT><br>

-------------------------------------------------
SELECT ...
WHERE
Category IN('#form.Category#')

I've tried a few different things, putting the ' 's on the form values, putting them on the SQL query, but the problem is that if multiple values are selected like Cat AND Dog, it submits the value 'Cat,Dog' instead of 'Cat','Dog'... and obviously 'Cat,Dog' is not found in the database...

Can anyone help? Thanks!!!

anyone? this is driving me crazy

try

thanks... sometimes it's just a matter of knowing about the existence of a particular function... that works great...

thanks again

You could also try:

listChangeDelims( list, "','", "," )

but listQualify() is a bit more elegant.