Recordset mysql with IN filter

Have you tried just setting it with a variable and then setting the variable
outside of your recordset? That's what I do (not with in, but similar
situations).

HTH,

Jon

"Shoshanaz" <webforumsuser@macromedia.com> wrote in message
news:e8j58m$ei0$1@forums.macromedia.com...
>I think this is a wishlist thing, but if it can be done, I'd like to know
>how.
>
> It would be very helpful if there was more robust support for the "IN"
> filter
> on recordsets.
>
> While it works 'ok" with numeric values i.e. WHERE whatsit IN (1,2,3)
> DW
> seems intent on not allowing a way to construct a query like
>
> WHERE state in (stateslist) -- where stateslist is a column variable
> ...
> e.g. .. $stateslist = "'MD','GA','PA'"
> because it insists on quoting the bejeezes out of it.
>
> Or... I could be missing something really obvious... Mostly it is for
> dealing with arrays (checkboxes for instance) being returned from a form
> and
> needing to process the info for each.
>
>
>
>