Re: [mapguide-users] SetFilter IN

2009-04-27 Thread Jackie Ng
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

Re: [mapguide-users] SetFilter IN

2009-04-27 Thread Kenneth Skovhede, GEOGRAF A/S
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

Re: [mapguide-users] SetFilter IN

2009-04-27 Thread Jackie Ng
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 = +

Re: [mapguide-users] SetFilter IN

2009-04-27 Thread Jackie Ng
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,