[mapguide-users] Exception in Filter Options

Jamo adam.jamison at portbris.com.au
Thu Apr 2 02:41:42 EDT 2009


string operator instead? just guessing haven't checked.
queryoptions.SetFilter("PARCEL_ID LIKE '785_1000' OR PARCEL_ID LIKE '708_584')")
?


Hi,
Parcel_ids are strings thats y i kept it in single quotes!!!!!!!!!!!!!!!!!!!!
but i got an error
can any body plz help me




Are the PARCEL_IDs strings or numbers?
If they are numbers, I'm thinking the statement should not have the
single quotes?

queryoptions.SetFilter("PARCEL_ID in (785_1000,708_584)")

Warren M

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of padmini
godavarthi
Sent: Wednesday, April 01, 2009 5:20 AM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] Exception in Filter Options




Hi,
iam using mapguide opensource 2.0 (with .net 2.0 +IIS 5.1)

While applying filter in queryoptions as


            Dim areaRuleTemplate As String =
File.ReadAllText(GetThemeXmlTemplatePath())

            Dim queryoptions As MgFeatureQueryOptions = New
MgFeatureQueryOptions()
            queryoptions.AddFeatureProperty("PARCEL_ID")

               queryoptions.SetFilter("PARCEL_ID in
('785_1000','708_584')")

            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)

i got an error as follows.

An exception occurred in FDO component.
ORA-00907: missing right parenthesis

can u plz tell me the solution?

Regards,
Padmini.
-- 
View this message in context:
http://n2.nabble.com/Exception-in-Filter-Options-tp2568455p2568455.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
_______________________________________________
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/Exception-in-Filter-Options-tp2568455p2573609.html
Sent from the MapGuide Users mailing list archive at Nabble.com.



More information about the mapguide-users mailing list