SQl In

[ctlcal]

Anyone have any easy suggestions on taking a list from a CF Flash form text box
to fill in the following sql. Replacing the tabs and spaces and unprintables
with quotes and commas

ID#s from the flash form

SELECT * FROM TABLE WHERE CMD_ID IN ('ID1', 'ID2','ID3'...etc)

Thanks..

[Brian Hogue]

Are you looking for a CF list? If yes, there are some functions for that.
hth

-brian

"ctlcal" <webforumsuser@macromedia.com> wrote in message
news:d4an16$p3v$1@forums.macromedia.com...

> Anyone have any easy suggestions on taking a list from a CF Flash form

text box

> to fill in the following sql. Replacing the tabs and spaces and

unprintables

> with quotes and commas
>
> ID#s from the flash form
>
> SELECT * FROM TABLE WHERE CMD_ID IN ('ID1', 'ID2','ID3'...etc)
>
> Thanks..
>