Query Struct output

[capik79]

Hi Experts,

I want to Query Out data in list.
MyList = john,mary,roger


When I make a query
Select * from login table where (userid in ('#myList#'))

It will return no data because it read like this
Select * from login table where (userid in ('john,mary,roger'))

I want it to read like this
Select * from login table where (userid in ('john','mary','roger'))

Thanks in advance

Shaffiq

[Stressed_Simon]

Read this thread from yesterday:-

[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=3&threadid=1017917&forumid=1[/url]

[capik79]

TQ Simon,

help me a lot

Regards,
Shaffiq