RE: [mapserver-users] Expression Syntax

2009-12-11 Thread Jay Kapalczynski
, David (MPCA) [mailto:david.fawc...@state.mn.us] Sent: Thursday, December 10, 2009 3:26 PM To: Jay Kapalczynski; 'Emiliano Castañeda' Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Expression Syntax At a minimum, I think that you will need to add quotes around the query columns

RE: [mapserver-users] Expression Syntax

2009-12-11 Thread Lime, Steve D (DNR)
[mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski [jkapalczyn...@ci.maple-grove.mn.us] Sent: Friday, December 11, 2009 8:37 AM To: Fawcett, David (MPCA); 'Emiliano Castañeda' Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Expression Syntax Thanks for all

RE: [mapserver-users] Expression Syntax

2009-12-11 Thread Jay Kapalczynski
: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Expression Syntax Try: FILTER ('[USE1_DESC]' =~ /.*%idOwnerQueryDESC%.*/i AND '[BLOCK]'='%idOwnerQueryBLOCK%') I've not tried case insensitive regex in a logical expression though. You might have to remove the i

RE: [mapserver-users] Expression Syntax

2009-12-11 Thread Lime, Steve D (DNR)
performance... Steve From: Jay Kapalczynski [jkapalczyn...@ci.maple-grove.mn.us] Sent: Friday, December 11, 2009 9:17 AM To: Lime, Steve D (DNR) Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Expression Syntax Thanks Steve for you response I

RE: [mapserver-users] Expression Syntax

2009-12-11 Thread Jay Kapalczynski
better performance... Steve From: Jay Kapalczynski [jkapalczyn...@ci.maple-grove.mn.us] Sent: Friday, December 11, 2009 9:17 AM To: Lime, Steve D (DNR) Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Expression Syntax Thanks Steve for you

RE: [mapserver-users] Expression Syntax

2009-12-11 Thread Lime, Steve D (DNR)
Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski Sent: Friday, December 11, 2009 12:08 PM To: Lime, Steve D (DNR) Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Expression Syntax My example I

[mapserver-users] Expression Syntax

2009-12-10 Thread Jay Kapalczynski
I looked on map server website in the documentation and cant get the synstax correct I have two textboxes idOwner and idOwner2 I am a bit confused on the FILTERITEM because I am trying to write the expression to include two fields. USE1_DESC and BLOCK are the two fields that form the query

Re: [mapserver-users] Expression Syntax

2009-12-10 Thread Emiliano Castañeda
Jay, you must use FILTERITEM only for simple FILTER expressions (string comparison only) for example: FILTER 2005 -fieldvalue FILTERITEM year -fieldname For Logical FILTER expressions you do not define FILTERITEM. In this case you must place the FILTER between parentheses, and fieldnames between

RE: [mapserver-users] Expression Syntax

2009-12-10 Thread Jay Kapalczynski
that were incorrect...seems like it grabbed all of them. Thoughts? From: Emiliano Castañeda [mailto:emilianocastan...@suremptec.com.ar] Sent: Thursday, December 10, 2009 2:13 PM To: Jay Kapalczynski Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Expression Syntax Jay, you

Re: [mapserver-users] Expression Syntax

2009-12-10 Thread Dan Little
Subject: RE: [mapserver-users] Expression Syntax Emiliano thanks for the response….yea I looked at the documentation and it was a bit fuzzy to me… If I do them individually it works: #FILTERITEM 'USE1_DESC' #FILTER /.*%idOwnerQueryDESC%.*/i

RE: [mapserver-users] Expression Syntax

2009-12-10 Thread Fawcett, David (MPCA)
, December 10, 2009 3:21 PM To: 'Emiliano Castañeda' Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Expression Syntax Emiliano thanks for the responseyea I looked at the documentation and it was a bit fuzzy to me... If I do them individually it works: #FILTERITEM

RE: [mapserver-users] Expression Syntax

2009-12-10 Thread Jay Kapalczynski
) [mailto:david.fawc...@state.mn.us] Sent: Thursday, December 10, 2009 3:26 PM To: Jay Kapalczynski; 'Emiliano Castañeda' Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Expression Syntax At a minimum, I think that you will need to add quotes around the query columns. (just use

RE: [mapserver-users] Expression Syntax

2009-12-10 Thread Jay Kapalczynski
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Jay Kapalczynski Sent: Thursday, December 10, 2009 3:57 PM To: 'Fawcett, David (MPCA)'; 'Emiliano Castañeda' Cc: mapserver-users@lists.osgeo.org Subject: RE: [mapserver-users] Expression Syntax Thanks all for your thoughts Got it...I