[mapguide-users] Filter Error

[Kenneth Skovhede, GEOGRAF A/S]

I can confirm that using the updated provider from the
SL-King page makes the IN operator work as expected.

Thanks.

Regards, Kenneth Skovhede, GEOGRAF A/S



Kenneth Skovhede, GEOGRAF A/S skrev:
> I was using the one that was included with FDO 3.3.2,
> I will try with a newer version at some point.
>
> Regards, Kenneth Skovhede, GEOGRAF A/S
>
>
>
> Haris Kurtagic skrev:
>> Which version of provider are using ?
>>
>> I remember that bug but it was solved sometime ago.
>> I just tried with Fdo2Fdo and set Filter with IN and it works fine.
>>
>> Haris
>>
>> -----Original Message-----
>> From: mapguide-users-bounces at lists.osgeo.org
>> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of padmini
>> godavarthi
>> Sent: Tuesday, May 05, 2009 10:44 AM
>> To: mapguide-users at lists.osgeo.org
>> Subject: [mapguide-users] Filter Error
>>
>>
>> Hi, iam using mapguide opensource 2.0 (with .net 2.0 +IIS 5.1) Now my 
>> problem is "In" operator is not working in Setfilter option
>>
>> My code is as follows..................................
>>
>>      Dim queryoptions As MgFeatureQueryOptions = New
>> MgFeatureQueryOptions()         
>> queryoptions.AddFeatureProperty("LINK_ID")         
>> queryoptions.SetFilter("LINK_ID IN (170,143,150)")         Dim 
>> increment1 As Double = IIf((5 > 1), 1.0 / (5 - 1), 1.0)         Dim 
>> str As String = layer.GetFeatureClassName()
>>         Dim dataReader1 As MgFeatureReader =
>> featureService.SelectFeatures(resId, layer.GetFeatureClassName(),
>> queryoptions)         While dataReader1.ReadNext()             value 
>> = GetFeaturePropertyValue(dataReader1, "LINK_ID")             
>> filterText = """ + "LINK_ID" + "" = "             filterText = 
>> filterText + value             areaRuleXML = 
>> String.Format(areaRuleTemplate, "LINK_ID" +
>> ":" +
>> value, filterText, InterpolateColor(portion, "00FF00", "00FF00", 0),
>> InterpolateColor(portion, "00FF00", "00FF00", 0))             areaDoc 
>> = New XmlDocument()             areaDoc.LoadXml(areaRuleXML) 
>>             areaNode = doc.ImportNode(areaDoc.DocumentElement, True) 
>>             areaTypeStyle.AppendChild(areaNode)             portion = 
>> portion + increment1         End While         dataReader1.Close() 
>>        
>>
>>
>> It gives me the following error
>>
>>     Dim dataReader1 As MgFeatureReader =
>> featureService.SelectFeatures(resId, layer.GetFeatureClassName(),
>> queryoptions)   as
>> An exception occurred in FDO component. ORA-00907: missing right 
>> parenthesis
>>
>> In this case Link ID  is  integer values not a string
>> value......................................
>>
>> can u plz tell me the solution  
>> i have also tried as
>>
>>    queryoptions.SetFilter("LINK_ID IN ({170},{143},{150})") but it gave
>> me
>> the error as "not a valid filter"
>>
>> Can anyone plz tell me the solution???????????????????/
>>
>> plzzzzzzzzzzzzzzzz
>> Regards, Padmini.
>>   
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users