[mapguide-users] Filter Error

[Kenneth Skovhede, GEOGRAF A/S]

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. 
>
>