We just had to solve this very problem this week in asp.net c#.
[with the ack that there are multiple ways to solve most problems]
The way we solved it is to understand that what the db needs is this:
IN (:parameter1, :parameter2, :paramater3, [..])
So you take your input string, split it, put
I'm looking for a way to use the IN sql syntax and parameters,
something like SELECT someField FROM someTable WHERE someOtherField IN
(1,4,6,8,12); .
Obviously I could build a string query from an array and execute that, but I'd
rather stay with parameters if at all possible.
If anyone knows,
2 matches
Mail list logo