Re: [mapguide-users] Filter query problem

2013-02-08 Thread lunab54
“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.” I think you don’t understand what I mean : This the Autodesk on line help and it’s very

Re: [mapguide-users] Filter query problem

2013-02-08 Thread Peter Shoemark
Yes I misread your first post Remy but thanks for your response and the Map hyperlink. Cheers, Peter On 08/02/2013, at 7:58 PM, lunab54 luna...@free.fr wrote: “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

[mapguide-users] Filter query problem

2013-02-06 Thread sidecar5
Team, I have a data set that has a colmn 'NAME' that includes a bunch called '?? ISLAND' I am trying to exclude the ISLAND tags by using (NAME '% ISLAND') without brackets as my filter but it does work. any helpers plz or a page where I can get basic examples?? I'm ,more than comfortable

Re: [mapguide-users] Filter query problem

2013-02-06 Thread Ryan Northcott
Try NAME NOT LIKE '% ISLAND' The % needs to be used with LIKE or NOT LIKE in SQL - sent via mobile iOS5 On 2013-02-06, at 4:58 PM, sidecar5 shoemark.pe...@gmail.com wrote: Team, I have a data set that has a colmn 'NAME' that includes a bunch called '?? ISLAND' I am trying to exclude

Re: [mapguide-users] Filter query problem

2013-02-06 Thread Rémy Gourrat
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: [mapguide-users] Filter query problem

2013-02-06 Thread Zac Spitzer
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 rgour...@ag-carto.fr 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

Re: [mapguide-users] Filter query problem

2013-02-06 Thread Peter Shoemark
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

Re: [mapguide-users] Filter query problem

2013-02-06 Thread Peter Shoemark
Ok, the solution. (found through Google) under some circumstances NOT LIKE and simply don't work. As an alternate try moving the NOT part of the code So what worked for me was NOT NAME LIKE '%ISLAND' Perfect. Hope others can get something from this. Cheers, Peter On Thu, Feb 7, 2013 at 1:21