Query using list

[kken]

Hi All:
I passed a comma delimited list of user ids into a parameter. The in the select record use ToText({USERS.user_id}, 0) in {?UserIDs}
The problem is, if the list = 1211,1311,1411, then it will pick up Users with ids of 211 and 131 and 411.

Is there a way in crystal to only query for each member of the list.


Thanks all.

 

[synapsevampire]

Make the parameter a multiple value parameter type and pass for each value, then your syntax is correct.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com