What if you single-quoted the values in the IN filter list?
- Jackie
KOBAH wrote:
Hello,
I hope users might have undergone this basic query filter in past.
districtQuery.SetFilter(Autogenerated_SDF_ID = +
district);
I just want to alter this filter to include multiple
I have used the IN operator like you show, and it works for me,
although not with the SDF provider.
Regards, Kenneth Skovhede, GEOGRAF A/S
Jackie Ng skrev:
What if you single-quoted the values in the IN filter list?
- Jackie
KOBAH wrote:
Hello,
I hope users might have undergone this
Another question I should've asked:
Are district1, distrct2 the actual values you are after or are they variable
names?
- Jackie
KOBAH wrote:
Hello,
I hope users might have undergone this basic query filter in past.
districtQuery.SetFilter(Autogenerated_SDF_ID = +
If they are variables, then your line of code should really be:
districtQuery.SetFilter(Autogenerated_SDF_ID IN ( + district1 + , +
district2 + , + district3 + ));
OR a cleaner version:
districtQuery.SetFilter(string.Format(Autogenerated_SDF_ID IN ({0}, {1},
{2}), district1, district2,