<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<a class="moz-txt-link-freetext" href="http://www.sl-king.com/fdooracle/download/download.html">http://www.sl-king.com/fdooracle/download/download.html</a><br>
<br>
Or, google "SL-King", and click the first result.<br>
<pre class="moz-signature" cols="72">Regarsds, Kenneth Skovhede, GEOGRAF A/S
</pre>
<br>
<br>
padmini godavarthi skrev:
<blockquote cite="mid:1241622984832-2817899.post@n2.nabble.com"
type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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: <a class="moz-txt-link-abbreviated" href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>
[<a class="moz-txt-link-freetext" href="mailto:mapguide-users-bounces@lists.osgeo.org">mailto:mapguide-users-bounces@lists.osgeo.org</a>] On Behalf Of padmini
godavarthi
Sent: Tuesday, May 05, 2009 10:44 AM
To: <a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
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.
</pre>
</blockquote>
<pre wrap="">_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
<pre wrap="">_______________________________________________
mapguide-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapguide-users">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
</body>
</html>