[mapguide-users] King.Oracle IN statement fails with a parenthesiserror WAS: Filter Error

[Kenneth Skovhede, GEOGRAF A/S]

One of my co-workers has seen the same issue,
so it's likely a bug in the provider.

Please create a bug report for the problem on the FDO site.

A dirty workaround is to use:
LINK_ID=170 OR LINK_ID=143 OR LINK_ID=150

Regards, Kenneth Skovhede, GEOGRAF A/S



padmini godavarthi skrev:
> 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. 
>
>