[mapguide-users] Filter Error

[padmini godavarthi]

Hi,
Thank u very much for ur reply
can u send me the url path for updated SL-King
Page........................................

Regards,
Padmini.
 

Kenneth Skovhede, GEOGRAF A/S wrote:
> 
> 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
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

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