XModPro

How to handle comma separated field vals via @vars ?

Matthias Kühnle Matthias Kühnle posted Jun 9, 2021
Active Jun 9 · Viewed 219 times

The follwing SELECT gives results when using:

CommandText="SELECT [UserID], [Email], [DisplayName] FROM Users WHERE CAST([UserID] AS VARCHAR(MAX)) IN (2,3,5)"

but nothing is returned (even no error) when using same SELECT with @var :
<Parameter Name="ProjectMembers" value="2,3,5"/>

Any idea why this does not work?

0 Replies

Loading replies...