[mapguide-users] Filter Error

[Haris Kurtagic]

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. 

-- 
View this message in context:
http://n2.nabble.com/Filter-Error-tp2791694p2791694.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users