Recordset mysql with IN filter

[Shoshanaz]

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.

[Newsgroup_User]

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.
>
>
>
>