[mapguide-users] Filter Error

[Kenneth Skovhede, GEOGRAF A/S]

http://www.sl-king.com/fdooracle/download/download.html

Or, google "SL-King", and click the first result.

Regarsds, Kenneth Skovhede, GEOGRAF A/S



padmini godavarthi skrev:
> 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
>>
>>
>>     
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20090510/16627718/attachment.html