Guys respectfully I think you are looking too deep. Yes most certainly NAME <> 'NEW SOUTH WALES' means I dont want NSW to appear from my Australia data feature source and it doesnt.
Likewise if I add....,"""""" and NAME <> 'VICTORIA' and NAME <> 'SOUTH AUSTRALIA'"""""", those states also disappear from my outline , exclude the inverted commas. I suspect in the background of the Layer resource Filter page is a hard code that says; Select * from your.featuresource where........... then you add your code here at the Layers->Filter line, which in my case is NAME <> 'NEW SOUTH WALES'. What I also want it to do is say code that equals.....NAME <> 'wildcard ISLAND' so that I dont get the NME NEW SOUTH WALES or any of the *ISLAND names. (NOT LIKE is fine in Oracle SQL and <> is fine in ESRI SQL but NOT LIKE doesnt work for me in Maestro). Hope that explains my predicament a bit better. Yes of course I could make a separate layer in MAP or ARC to separate the *ISLAND bit but I am sure that wont be necessary with help from this group. Cheers, Peter On Thu, Feb 7, 2013 at 12:26 PM, Zac Spitzer <[email protected]> wrote: > I'm not 100% certain, but I think NAME might be a reserved word in some > FDO providers? > > > On Thu, Feb 7, 2013 at 10:02 AM, Rémy Gourrat <[email protected]>wrote: > >> I believe with fdo it's a little different, you must put "no" first >> >> Not name like '%island' >> >> If you have an autodesk map you have a good help about. >> >> Rémy Gourrat >> AG-Carto - Bayonne >> >> ------------------------------ >> View this message in context: Re: Filter query >> problem<http://osgeo-org.1560.n6.nabble.com/Filter-query-problem-tp5032605p5032621.html> >> >> Sent from the MapGuide Users mailing list >> archive<http://osgeo-org.1560.n6.nabble.com/MapGuide-Users-f4182607.html>at >> Nabble.com. >> >> _______________________________________________ >> mapguide-users mailing list >> [email protected] >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> > > > -- > Zac Spitzer > Solution Architect / Director > Ennoble Consultancy Australia > +61 405 847 168 > > > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > >
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
